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


Peter,

I have set up the output swing table to show  query result page by page. This way
the speed of the complete query should not be so critical if the query returns
the first page of date before the complete query is finished. With informix db
the first page with around 30 rows of the output is shown in say three seconds,
with 103 rows in the database. If the database is normalized and contains
different data 15 tables, in my opinion, should be rather typical than something
special. I will build an example program for you this evening. I have to go out
of office now but will send the example when i am back.

Regards
Thomas Vatter


Peter Hearty schrieb:

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

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