1. I am able to test Kannel + SQL Box and DLR.
2. Also I understand that I have to provide my own generated MsgID(uuid) in DLRUrl and on receiving DLR, my script will query for SMS record with MsgID(uuid) and update the DLR status. 3. To send the SMS, I have script which inserts SMS in SQLBox table send_sms which finally gets moved to sent_sms. 4. My question is do I need my separate tables to store MsgID(uuid) as noted in step 2 above ? If yes; this will Involve Injecting SMS in 2 tables. One - MyOwnSMS table and Two - SQLBox send_sms table; which seems the be bit of overhead for server at high throughput. 5. In other words, I am wondering, can I use existing tables of SQLBox (say table sent_sms) to store MsgID(uuid) and update the same using DLRurl on receipt of delivery report. i.e. Is there any field in tables send_sms and sent_sms which may be used for storing MsgID(uuid) generated by our submit script, and the field gets carried from send_sms to sent_sms automatically ? or is it recommended to edit the SQL box code to achieve this rather than having separate table as discussed in above point ? or having separate table will not be much of overhead ?! 6. I hope many users here are using Kannel at very high load conditions and would be able to share their experience with me. Bharat
