Yes, I'm already connected
I've written a threaded connection pool (although this query executes in the
context of the main thread) that re-uses database connections.

The results below was from Database Workbench which I am pretty sure keeps
the database connection open? Anyways - its slow in both instances.
But I'm about to make sure that the connection being grabbed from the pool
is connected before I execute the query...

Thanx for the help so far... :)
Louis

----- Original Message -----
From: "Milan Babuskov" <albis@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, June 26, 2003 11:32 AM
Subject: Re: [firebird-support] Sloooow query


> Louis Louw wrote:
> > Hi!
> >
> > songlist.ID is a primary key and I just make an index for
> > categorylist.songID as well as songlist.date_played and
date_artist_played
> >
> > This made the query execute in 2.4 seconds. A lot better...
> > But still not near the 0.1sec I'm used to with MySQL :(
>
> Are you sure it's "query execution time" ?
>
> If you're doing connect + exec query, then it's probably the difference
> between connection time. Firebird needs a sec or even more to establish
> connection, while MySQL does it instantaneously.
>
> What tool do you use to connect? PHP?
>
> Perhaps you can put timestamping code right after connect so you can
> measure the speed of the query itself precisely...
>
> --
> Milan Babuskov
> http://fbexport.sourceforge.net
> http://njam.sourceforge.net
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>