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**** > > **** > > ** ** >
