Subject | Speeding up deletes |
---|---|
Author | Don Gollahon |
Post date | 2003-06-17T19:09:13Z |
I'm deleting 1000's of records (commiting every 100) and the process I'm
using is working very well. It is running at around 100/deletes per second.
Is there a way to speed this up? I'm using Delphi 5 and IBX 5.03. (I know,
I'm working on getting management to let me switch to IBO). During the
deletes there will be no other users in the database. I'm using FB 1.02.
Should I do a database shutdown, turn off forced writes during the process,
or what?
To let you know, my delete process is still running and it has deleted
700,000 records so far. This process will have to run weekly.
Thanks.
Don Gollahon
gollahon@...
"The Original GenSoft Prodigal"
using is working very well. It is running at around 100/deletes per second.
Is there a way to speed this up? I'm using Delphi 5 and IBX 5.03. (I know,
I'm working on getting management to let me switch to IBO). During the
deletes there will be no other users in the database. I'm using FB 1.02.
Should I do a database shutdown, turn off forced writes during the process,
or what?
To let you know, my delete process is still running and it has deleted
700,000 records so far. This process will have to run weekly.
Thanks.
Don Gollahon
gollahon@...
"The Original GenSoft Prodigal"