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