> Thanks all so far, we're lookin at running with -g during the day and a
> garbage enabled one at midnight
>
>
>
> However talking to our developer he's not convinced hes' using
> transactions?

I'm afraid, I can of worm then, because the access components are
therefore responsible for doing the transaction stuff, thus leading to
problems like using CommitRetaining when using some kind of AutoCommit.

It's very important to understand Firebird transactions and how to use
them with the access components correctly.




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