Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: SQL query does not run


Thomas

It's probably just labouring its way through the 14 table join. InstantDB
doesn't do much in the way of optimisation of Joins. If you put together a
script/program that sets this up for me then I could take a look at it, but
it's probably always going to be pretty slow.

How fast does the query run on other DBs?

Regards

Peter Hearty
Lutris Technologies UK Ltd.
-----Original Message-----
From: Thomas Vatter <thomas.vatter@blinx.de>
To: instantDB@enhydra.org <instantDB@enhydra.org>
Date: 02 July 2000 22:06
Subject: Re: InstantDB: SQL query does not run


>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.
>

-----------------------------------------------------------------------------
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.