Well last week The same issue was raised on another thread in this mailing list. Let us consider the amount of time sqlbox has to do database CRUD for 1M messages compared to using spool or files. Is there anyone who has worked with both?
On 4/21/15, Rene Kluwen <rene.klu...@chimit.nl> wrote: > 1. > I think Kannel does support Keep-Alive connections. Not sure about the > server side, but I think it does. Just make sure your client also supports > it. > > 2. > Yes, probably SQL Box does insert 1,000,000 a lot faster than you can do by > http. Question is if your upstream providers handle such a rate. You will > end up with a lot of pending messages in the bearerbox queue. > > == Rene > > > -----Original Message----- > From: users [mailto:users-boun...@kannel.org] On Behalf Of Cliff Court > Sent: dinsdag 21 april 2015 10:11 > To: users@kannel.org > Subject: Fastest method to insert a million MT messages to Kannel > > Hi All > > I have set up Kannel with bearerbox and smsbox, which is working and I am > writing dlr's to a mysql db. > > Currently I am submitting messages using a sendsms GET or xml-based POST, as > per the Kannel documentation. However, using individual http GET or POSTs > for each message is relatively slow when needing to send a large volume of > messages. Let's assume I have a 100 msgs/sec connection to an external SMSC > using SMPP from bearerbox, which will take ~3 hours to send 1 million MT > messages. > > So my question is what is the fastest method to submit messages to bearerbox > to send a million MT messages? > > I have seen that SQLbox is available and that one can insert messages into > the send_sms table for faster submission, but I'm wondering what is the > fastest method of submission to bearerbox? > > Thanks > Cliff > > > > -- -- Kind Regards. *Makhanu Sinja.* +254 (0) 72168 0868 *I do know everything, just not all at once. It's a virtual memory problem.*
