Subject Re: [firebird-support] Re: Issue with large table in FB 1.5 and 2.5
Author Thomas Steinmaurer
> 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

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.