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?