Peter,
I did some further testing and found the following.
When I use my insert routine that works with redundancy checks insert is ok with
a data set (coming from one single word table) with 13 rows. Query shows the
results rather quickly.
When I do the same with a data set with 103 rows query does not come to an end
after 10 minutes. CPU usage is 100 %.
I checked the contents of the database via JDBCMain but could not find any wrong
references or data.
Regards
Thomas Vatter
Peter Hearty schrieb:
> Thomas
>
> In that case, I'd need to see a script that created the tables, added a few
> rows and then tried to do the query.
>
> Regards
>
> Peter Hearty
> Lutris Technologies UK Ltd.
> -----Original Message-----
> From: Thomas Vatter <thomas.vatter@blinx.de>
> To: instantDB@enhydra.org <instantDB@enhydra.org>
> Date: 01 July 2000 14:45
> Subject: Re: InstantDB: SQL query does not run
>
> >I changed the prp file and tried again. I fear it didn't help. Here is the
> output
> >from commsql and the prp file
> >
>
> -----------------------------------------------------------------------------
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|