We delete DLR after 2 months after their creations if they are still in our db. A simply SQL request would do that easily.
Vincent -- Telemaque - 06200 NICE - (FR) Service Technique/Reseau - NOC Developpement SMS/MMS/Kiosques http://www.telemaque.fr/ [EMAIL PROTECTED] Tel : +33 4 93 97 71 64 (fax 68) ----- Original Message ----- From: "David Ritchie" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 29, 2006 4:39 PM Subject: DLR storage in MySQL We're storing DLRs in MySQL successfully but the DLRs aren't being deleted which seems at odds with other people's experience (i.e. http://www.kannel.org/pipermail/users/2006-August/000294.html) but makes sense, since often we include a dlr-mask value (e.g. 12) which result in multiple DLRs being returned. Can anybody outline any successful DLR archiving or deletion strategies they've implemented, or perhaps outline how we can delete DLRs after a certain expiry date? Is there a danger (other than disk space issues) in letting the DLR table grow? Thanks! David R
