Hello Ravindra,
1. The sent_sms table is a log table. It records all sms messages that have been sent, either through a connected smsbox or via an insert in send_sms. Entries are never deleted. If you don't need a log of your sms messages, you can comment out the line "gw_sql_save_msg(msg, octstr_imm("MT"));" in the gw/sqlbox.c file. 2. If you don't need them, you can just delete everything from the sent_sms table, for instance in a cron table. Or otherwise, see 1. 3. sqlbox doesn't manage an internal queue. If you need information about the sqlbox queue size, just apply a "select count(*) from send_sms" and it will give you the number of messages still in the queue. 4. There's several options. If you don't need a log of the messages that are sent, comment out the line that saves sent messages (see 1.). Also, if you want to increase speed of inserting messages in send_sms, you can look at the mysql syntax "INSERT. DELAYED". This is what your client program should do. Another thing is to adjust the SQLBOX_MYSQL_SELECT_QUERY query in gw/sql_mysql.h. You can increase LIMIT 0,1 to a bigger value. I never bothered to test this out on high volumes. So please feel free to test and share your experiences in the list. Also there's a number of things you can do to increase mysql speed, which is beyond the scope of this mailinglist. Hope this helps, Rene From: Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com] Sent: Wednesday, 08 August, 2012 09:34 To: Rene Kluwen Cc: us...@vm1.kannel.org Subject: Re: dlr-url call on sqlbox Dear Rene, While working on sqlbox, I have come across some queries :- 1. When we insert on send_sms table, it invokes and sends it to sent_sms which further submits it to the Operator and it deletes the entry from send_sms. However when we receive the deliver_sm from operator, it doesn't deletes the entry from sent_sms table. 2. If the above scenario continues it would increase the size of sent_sms table and will affect the mysql performance. 3. How we will manage queue in sqlbox, is there any patch available which will give us the queue related information. 4. How to increase insertion speed to send_sms tables or sent_sms table. On Wed, Aug 1, 2012 at 6:24 PM, Rene Kluwen <rene.klu...@chimit.nl> wrote: I don't understand quite what you mean with your questions. But to answer: 1. Yes, you can send bulk sms through smsbox. It should work better than sending them via smsbox. 2. Performance issues are dependant of a number of things. Check the complete chain (smsbox -> sqlbox -> mysql -> bearerbox -> smsc). Usually sqlbox is not the cause. == Rene From: Ravindra Gupta // Viva [mailto:ravin...@vivainfomedia.com] Sent: Wednesday, 01 August, 2012 12:29 To: Rene Kluwen Cc: us...@vm1.kannel.org Subject: Re: dlr-url call on sqlbox Dear Rene, Thanks for your response. We have successfully configured SQLBOX in our server. We need some query as given below. 1. Can we send bulk load using SQLBOX i.e ( 5 to 10 Lac sms). 2. SQLBOX totally on database so any performance issue occurred when we have inserted 1 Lac to 10 Lac sms. 3. We have used mysql 5.5 version. Kindly share your expert sugesstion for the same. On Wed, Aug 1, 2012 at 3:05 PM, Rene Kluwen <rene.klu...@chimit.nl> wrote: The error is self-explanatory. You should just dlrencode your parameters in the dlr-url. Not the url itself. So insert: http://10.0.0.1/sms/dlrNEW.php?dlr=%25d%26to%3D%25p%26smsID%3D%25A%26BatchID %3Dravi123-5d12d21asdq1asravi == Rene