Re: Slow deleting records

: Dave's News wrote in message ...
: >I have a table that only has 15000+ records but when I try to delete all
 the
: >records it takes forever. We benched marked it to about 15 minutes per
 1000
: >records. The only thing I can think that may cause this is that this table
: >has a long datatype field but most records are very small.
: >
: >Any ideas would be appreciated.

From the limited information you gave, it sounds like you may have indexes or triggers in the offending table. Indexes are nice for searching specific fields, but for updates, deletes, and inserts, they are a nightmare.

I would suggest temporarily removing any indexes on the table. Do whatever operations you need to do. Then reinstate the index afterwards. It will save you a lot of time. Same for the triggers. Triggers will execute on every execution. So they would add to the delay when performing an operation on 15000 records. Remove them, do what you need to do with the table(s), then put them back when you're done.

Good luck.

                        -Dave Received on Fri Nov 13 1998 - 00:00:00 CET