--- In firebird-support@yahoogroups.com, "Jerome Bouvattier"
<JBouvattier@I...> wrote:

> Hi,
>
> Once a db has been swept, and provided there is no other connection

to the

> database. Shouldn't subsequent SWEEPs be almost instantaneous ?
>
> If "yes", what could cause my subsequent SWEEPs still to take a lot

of time

> ? (don't know if it's as much or less than the first SWEEP though)

Jerome, what is "a lot of time"? If not few minutes - most probably
condition this mean there was not other connection and long ago
started within it write transaction was not provided. Main task for
sweep is to move Oldest Transaction, collection of garbage freed in
this process is secondary effect. Check gstat -h after sweep and if it
differs from Next more than a few ones, my guess is right.

Best regards,
Alexander.