| Subject | Re: [firebird-support] SWEEP active for more than 3 hours ??? |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-07-06T16:00:51Z |
ddresse wrote:
duplicates - but it's a terrible waste of time. If you're emptying a
database, shut it down, delete it, and create a new one. If you don't
have a script to create a new database, do a metadata only backup -
(gbak -b -m -g <db> <backup>), and restroe that to create a new
database. If you have anything you care about in the database other
than the metadata, do a backup with garbage collection turned off (gbak
-g -b <db> <backup>), and restore that.
The cost of cleaning up after deleting everything is enormous... and
almost always unnecessary.
Regards,
Ann
> I activated a SWEEP (via IBExpert)... and process is active now forIt's probably normal, depending on the number of indexes with lots of
> more than 3 hours. Is it normal ?
>
> For information, we have set Database to blank, (executing a 'DELETE'
> on all database tables). Two tables had more than 1250000 records...
> I assume it must take some time to clean the stuff, but more then 3
> hours seems to be a little too much !
duplicates - but it's a terrible waste of time. If you're emptying a
database, shut it down, delete it, and create a new one. If you don't
have a script to create a new database, do a metadata only backup -
(gbak -b -m -g <db> <backup>), and restroe that to create a new
database. If you have anything you care about in the database other
than the metadata, do a backup with garbage collection turned off (gbak
-g -b <db> <backup>), and restore that.
The cost of cleaning up after deleting everything is enormous... and
almost always unnecessary.
Regards,
Ann