> -----Original Message-----
> How can the fact that I just inserted the rows to the
> database affect the time it take to query the table?
>
> Why is it so much faster after I re-open the connection to
> the database??

A shot in the dark, are you committing the transaction after inserting all
your records?

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://www.tectsoft.net/ - Homepage