AnsweredAssumed Answered

Deletion speed ups

Question asked by tmlutas on Dec 26, 2010
Latest reply on Dec 27, 2010 by philmodjunk


Deletion speed ups


I'm regularly deleting and recreating large numbers of records by emptying a table. I've got a bit over 300,000 records and when I say delete all records, it starts off by deleting about 100 records at a time and then it speeds up. 

I've no idea why a delete should start so slow and then speed up as it goes along. Why the speed differences?