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

> Hi again,
>
> Suppose I have exclusive access to my db, theoretically, what

"should" be

> the quickest way to achieve a SWEEP : Straight SWEEP or Backup &

Restore ?

If you mean Oldest Transaction movement and garbage collection - on
large databases usually sweep (if there are not TONS of garbage and
transactions gap is'nt measured in millions). For example, my 8Gb
database having several thousands gap is nightly sweeped in ~10
minutes, backup process require ~30 minutes and restore ~4 hours. If
you mean indices rebuilding too, including system ones, you need
backup with garbage collection switched off and restore.

Best regards,
Alexander.