The most common dlr-mask to use is indeed 31, but what's the best one is something you need to check for yourself, since it will depend on your own needs. Some people need all possible DLRs, some need only final status ones, and some don't need them at all. So what dlr-mask to use depends exclusively on your own needs.
Regarding when to erase old DLRs, the best will be to ask the guys from the SMSCs against to which you connect and ask them about it. The typical is indeed that SMSCs expire DLRs after 2 or 3 days, but some may do even more. Erasing 1 week old DLRs as you mentioned seems safe, but I would suggest asking them, cause you will probably be able to erase them before, and that will make your DB suffer less with the deletes since they will be smaller. Another thing to take into account when deleting old DLRs, specially if using MyISAM tables (MySQL), is to delete them not all together at once but in batches in order to not generate locking in your tables (write operations on MyISAM tables lock the whole table, and InnoDB tables suck while doing COUNTs so if you use the http admin interface for Kannel, then InnoDB is not a good option cause it needs to issue COUNTs to get the DLR numbers, etc). Regards 2010/9/22 Jarratt Ingram <jarr...@ambientmobile.co.za>: > Hi Nikos, > > Thank you for your prompt reply, I am using mysql dlr storage so will write > a cleaning script that removes dlr's after a week. > > Kind Regards > Jarratt > > On 09/22/2010 08:37 AM, Nikos Balkanas wrote: >> >> Hi, >> >> Pending DLRs correspond only to final DLRs with mask = 3 (delivered or >> not). You should not skip those. Depending on mobile availability, powered >> off, etc., SMScs will try sending the SMS for 2 days usually, before >> returning an EXPIRED DLR. The rest DLRs, accepted and buffered, are not an >> issue, since they are returned immediately when the SMS is sent. >> >> In summary. You should at least wait a couple of days for DLRs to arrive. >> You should periodically delete pending DLRs from your DB, older than 3-4 >> days, assuming you use a DB for dlr-storage. Best mask to use is 31. >> >> BR, >> Nikos >> ----- Original Message ----- From: "Jarratt Ingram" >> <jarr...@ambientmobile.co.za> >> To: <users@kannel.org> >> Sent: Wednesday, September 22, 2010 9:24 AM >> Subject: DLR best practice >> >> >>> Good Morning, >>> >>> This is more of a best practice question, What is the best DLR mask to >>> set, currently we have it set as 31 to get all DLR's, we have sent over half >>> a million sms's over the past week and still have around 95k dlr's >>> outstanding. Should we be using 31 or should i just set it to get dlr's for >>> errors and delivered to handset ? >>> >>> Is it normal for DLR's to take days to return ? Sorry were a little new >>> to the game so just trying to find our feet. >>> >>> Kind Regards >>> Jarratt >>> >> > > >
