(sorry, forgot to copy the list)
The way you are using dlr's and matching is, usually is the correct way. You should profile your application if the load gets too high. If it is a database issue, maybe an index on dlr_url will help. Alternativly you can use a MySQL trigger. See http://dev.mysql.com/doc/refman/5.0/en/triggers.html == Rene From: users [mailto:users-boun...@kannel.org] On Behalf Of Alok Srivastava Sent: donderdag 18 juli 2013 6:23 To: users@kannel.org Subject: For tracking delivery report DEar Please help me, i am making an application on kannel and using only bearerbox and sqlbox. problem is that when i submit message in send_sms table, my application has a trackid for every message, which i have to use for collecting delivery report from sent_sms table but i have no option to insert the record in send_sms table with this trackid and collecting delivery report on the basis of this trackid from sent_sms table. Is there any other way to do this. presently i am inserting a trackid variable in dlr_url field of the send_sms table. but when i get this in sent_sms table it is encoded. and when i collect deliery report from sent_sms table, first it decodes dlr_url and fetch trackid field then match it , it is taking too much time and increasing load of the server too much. Is there any other way to do it or can i hit any API to update my database when delivery report updated in sent_sms table. Please help, thanks. abhi