Subject Re: sweep rule of thumb timings
Author csswa
D'oh! I just realised I failed to mention something that almost
certainly has a bearing on my test timings...

The 100-meg database is comprised of a little over a million records:
5 fields of test data (pk integer, firstname, phone, country...)
filled with random-but-relevent data.

In light of the number of records, is 16 min for a sweep on the setup
below acceptable and in line with expectations?

It's also strange that a backup on this db takes about two minutes
(ditto for restore) since a sweep is also part of that process.

Andrew Ferguson

--- 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.
> Are these figures in line with what you would expect? I'd like to
> hear other examples of sweep times for comparison.
> Thanks,
> Andrew Ferguson