Two things that may help:

1) Making non-selective indexes selective by adding the primary key to the
end of the index (deletes will slow down when using non-selective indexes
since they will have to search through a lot of records with the same value
in the index to find the record to be deleted).

2) Commiting not quite as frequently (maybe every 10000, not every 100)

HTH,
Set

At 14:09 17.06.2003 -0500, you 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?
>
>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.