> Also one further question.... Do later versions of Firebird (ie. 3 or > 4) have any performance increase for cooperative garbage collection at > all? Would I expect to see any performance improvement by any newer > version, or different server implementation here?
Likely TRUNCATE TABLE ... in Firebird 4.0 comes to rescue here: a) No need to drop/create dependent objects like SPs etc. in the DROP TABLE use case b) Won't suffer from garbage collection as with deleted data from the table. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
