> Thank you for all your answers.
>
> I suspect house keeping. I will try some tests and will come back to
> you again if I'm still having problems.
>
> For your information, even if I'm using Delphi, I load data into
> memory when the program start and I close all queries.

Closing the query doesn't necessarily mean that the transaction has been
ended as well. ;-)


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/