On Tue, 17 Jun 2003 19:09:28 +0000 (UTC), Don Gollahon wrote:

> 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?

Dropping indexes (or de-activing them) might make a difference.


--
Aage J.