I have an application that deletes about 2,000,000 records per night. I
simply do it using SQL, DELETE FROM MyTable WHERE DeleteCondition. I set
any indexes to INACTIVE first the Reactivate them.

The first and only time I turned forced writes off I have a power
failure over night and ended up with a corrupted database table.
Regards
Peter Gore



-----Original Message-----
From: Don Gollahon [mailto:gollahon@...]
Sent: 17 June 2003 20:09
To: Ib-Support
Subject: [firebird-support] Speeding up deletes


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"





Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=249982.3179269.4495679.1261774/D=egroupweb/S=1705
115386:HM/A=1524963/R=0/SIG=12ongbbsq/*http://hits.411web.com/cgi-bin/au
toredir?camp=556&lineid=3179269&prop=egroupweb&pos=HM>

<http://us.adserver.yahoo.com/l?M=249982.3179269.4495679.1261774/D=egrou
pmail/S=:HM/A=1524963/rand=633472078>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]