Re: fast way to delete records?
My first thoughts are that if you are deleting massive amounts of data, they take a long time. Your delete has to leave approximately 6,048,000 records (60 * 60 * 24 * 7 * 10). Running your delete more often should yield fewer rows to delete and speed up the process.
You could try swapping the indexes and use "DTIME,Site" as the primary. You may get better performance with the PK for the deletes.
Also, since you are using MyISAM, try converting "site" to char(4) from a varchar(4). That way your record is fixed length and not variable. This should help a bit - more if your data has fewer characters than 4; less if your data 4 characters. With tens of millions of records, every little bit helps.
I hope this helps.
Subject
Views
Written By
Posted
14649
May 23, 2006 03:35PM
Re: fast way to delete records?
7075
May 24, 2006 07:29AM
6388
May 24, 2006 06:43PM
4729
June 08, 2006 12:30PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.