I think ADO uses bigger cache so it can work longer only in memory. Transactions can help, but in case of many updates/inserts there is not enought space in cache, so the rows are stored on disk.
-- Regards Michal Zaborowski (TeXXaS) http://sqlite4delphi.sourceforge.net/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
