You can add a field to the dlr table of type TIMESTAMP (in mysql). This will get filled with the current date/time upon insert-time.
After 10 days you can delete all the records that have that field set to older than 10 days. == Rene From: [email protected] [mailto:[email protected]] On Behalf Of Tapan Thapa Sent: Monday, 02 April, 2012 09:55 To: [email protected] Subject: Kannel - DLR Storage - MySQL Hello Community, I had enabled dlr-storage under kannel to store delivery report in mysql database and now dlr table is having more then 8 (.8 million) lacs records. Can any one let me know how should i delete old dlr from database for which i have not received the delivery report since last 10 days? Thanks in advance. Regards Tapan Thapa
