Hello, Nick! Tuesday, July 30, 2013, 12:37:09 PM, you wrote:
NU> I am running classic firebird 2.1, but I don't think its GC as I ran both a NU> sweep and a backup and still got the same, longer, time to be sure that this is not GC, you may - after inserting and updating data run gstat -r or IBAnalyst here you can see, are there record versions, or not - after running sweep run gstat -r or reload stats in IBAnalyst here you can see, was sweep or GC effective (i.e. less versions or not) - after restore run gstat -r or reload stats in IBAnalyst here you can compare size of your table, and see was it fragmented or not -- Dmitry Kuzmenko, www.ib-aid.com
