Backup after large deletion extremely slow/looping?
Backup after large deletion extremely slow/looping?
(OP)
I am having problems deleting 1.6 million records from my Interbase 4.0 database. The records contain BLOB data.
A backup run before the deletion completed in an hour. After the deletion, the backup ran for four hours and then I had to kill it. I ran data validations before and after the deletion and there was no corruption found. The deletion took 20 minutes to complete and showed no problems. I cannot determine whether there is a problem with the backup process or it just takes that long.
Any help is greatly appreciated.
A backup run before the deletion completed in an hour. After the deletion, the backup ran for four hours and then I had to kill it. I ran data validations before and after the deletion and there was no corruption found. The deletion took 20 minutes to complete and showed no problems. I cannot determine whether there is a problem with the backup process or it just takes that long.
Any help is greatly appreciated.
RE: Backup after large deletion extremely slow/looping?
Turn OFF garbage collection during the backup process - it will speed up the backup. However, "garbage" (old record data) needs to be deleted - this will be done when the user does, for example, a SELECT * FROM tablewhereyoudeletedalargenumberofrows ... InterBase 6 and 7 have several improvements related to the garbage collection process.
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.upscene.com
RE: Backup after large deletion extremely slow/looping?
Does that mean that the backup after the purge is working correctly, even though it is taking forever?
RE: Backup after large deletion extremely slow/looping?
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.upscene.com
RE: Backup after large deletion extremely slow/looping?
The goal is to reduce the size of the database. As long as I know the backup with garbage collection is working, I will schedule time to allow it to finish.
RE: Backup after large deletion extremely slow/looping?
To shrink the file, you have to restore your db - but in order to restore, you don't need to garbage collect anyway (as you will be using a completely new file, with no garbage in it)
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.upscene.com
RE: Backup after large deletion extremely slow/looping?
You are saying I can do a backup with garbage collection off (it will run quicker) and a restore and this will shrink my database.
Wonderful!
Thank you for all your help.
RE: Backup after large deletion extremely slow/looping?
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.upscene.com