Hi Louis,

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

Yes, it does. Mind you though, Database Workbench does more than a
simple execute - it tries to make the resultset editable as well and
therefore
queries the metadata etc etc. If you want to measure your time - exactly -
then measure it in your application.

> But I'm about to make sure that the connection being grabbed from the pool
> is connected before I execute the query...

Can you post the COMPLETE DDL - including constraints, indices etc?

Post the (new) plan as well.

What version of Firebird are you using?


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com