Re: Slow deleting records
Date: 1998/11/08
Message-ID: <724j1o$fkt$1_at_uranium.btinternet.com>#1/1
After over 10 years as a dba covering MS-SQL, Sybase, and Oracle I find the
latter to be far the slowest at delete operations. You do have to consider
you're rollback configuration and make sure its not wrapping excessively
etc. You should also be aware that deletes do not reset a tables
highwatermark which will effect your disk usage and tablescans greatly.
truncate is near instant but deletes entire table contents NOT sets of data.
delete allows you to delete sets of data based on criteria but is a
*considerably* slower and performance dependant on disk and rollback
configuration etc.
Dave's News wrote in message ...
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.
>
>
Received on Sun Nov 08 1998 - 00:00:00 CET