Subject | Problems after many records deleted |
---|---|
Author | fabiano_bonin |
Post date | 2004-05-13T17:29:09Z |
I had a table with 200.000 records.
I deleted 180.000 records from this table.
Now i'm trying to backup my database and the gbak stop in this table
and never go away.
I didn't wait so much (about 5 minutes), but other tables are almost
instantly.
I remember i read here there is some problem with garbage collection
when deleting many records and this behavior is expected.
Am i right? If yes, is there some workaround to avoid this delay?
Thanks.
I deleted 180.000 records from this table.
Now i'm trying to backup my database and the gbak stop in this table
and never go away.
I didn't wait so much (about 5 minutes), but other tables are almost
instantly.
I remember i read here there is some problem with garbage collection
when deleting many records and this behavior is expected.
Am i right? If yes, is there some workaround to avoid this delay?
Thanks.