Try adding relevant indexes for dlr table. UNIQUE KEY `smsc_ts_destination` (`smsc`(15),`ts`(35),`destination`(11))
2012/7/16 Eric Turner <e...@txtwire.com> > Since it is compiled code. You could either look through the source code > and see where you could make improvements or you could add a second sqlbox. > > > > On Sun, Jul 15, 2012 at 2:47 AM, Ashish Agarwal <ashisha...@gmail.com>wrote: > >> Hello, >> >> With sqlbox I have around 15,00,000 number of record in send_sms table >> and bearerbox is sending sms at approximately 200 to 300 TPS, but bearerbox >> with my smsc has much higher capacity to submit sms to smsc around 400 to >> 500 TPS but since sqlbox is not able to send too many sms to the store of >> bearerbox at a time I am not able to achieve good throughput with my smsc. >> >> Therefore, is there a way wherein sqlbox can read messages from send_sms >> table at a very high speed so that message can be stored in queue and my >> smsc connections can be utilize to the maximum. >> >> Please suggest. >> >> -- >> Regards, >> >> Ashish Agarwal >> > >
