Subject Re: sweep rule of thumb timings
Author alex_vnru
--- In ib-support@y..., "csswa" <csswa@y...> wrote:
> On my 850mhz NT workstation, a sweep of a one-hundred meg db with
> minimal garbage took about 16 min. Based on this, a sweep of a one-
> gig db would take at least two hours forty-five min.

Andrew, sweep duration is related to amount of garbage record
versions and gap between OAT/OIT and current transaction in much more
degree than to file size. My 2.7Gb database which is modified by 20
users daily mainly by inserts and updates of non-indexed attributes
(I have no idea what is transactions gap at sweep start but it should
be very little) is sweeped nightly by cron and elapsed time is 1.5 - 2
minutes. Of course we have different hardware (2Xeon 933, RAID 5) OS
(Linux) and FB (Classic) but IMHO it shouldn't be of very high value.

Best regards, Alexander V.Nevsky.