unsubscribe
_
Renato A. R. Goncalves
Eng. De Integração
SÃO PAULO
DESK: +55 11 2575-6817
MOBILE: +55 11 9254-7999
De: users-boun...@kannel.org [mailto:users-boun...@kannel.org] Em nome de
Rene Kluwen
Enviada em: quinta-feira, 19 de julho de 2012 16:41
Para: 'Ashish Agarwal'
Cc: 'users'
Assunto: RE: sqlbox select speed
Doesnt really matter. As long as it is different from any other port that
you are using already.
From: Ashish Agarwal [mailto:ashisha...@gmail.com]
Sent: Thursday, 19 July, 2012 17:54
To: Rene Kluwen
Cc: users; Eric Turner; spameden
Subject: RE: sqlbox select speed
What should be the smsbox-port value I should mention in my new sqlbox
configuration.
On Jul 19, 2012 6:27 PM, Rene Kluwen rene.klu...@chimit.nl wrote:
Theres no absolute need for two smsboxes to be connected, as long as you
set your boxc_id to the smsbox that you have.
Having said that, in your case, two smsboxes might improve speed as well.
== Rene
From: Ashish Agarwal [mailto:ashisha...@gmail.com]
Sent: Thursday, 19 July, 2012 09:09
To: Rene Kluwen
Cc: Eric Turner; spameden; users
Subject: Re: sqlbox select speed
Hi Rene,
Thanks for the response. I have configured two sqlboxes that are reading
from two different database and that has helped in increasing the overall
speed. I have not recompiled sqlbox with INSERT DELAY.
Also, I want an understanding whether if two smsboxes are also necessary
with two sqlboxes.
On Tue, Jul 17, 2012 at 3:37 AM, Rene Kluwen rene.klu...@chimit.nl wrote:
To shed some light in this matter.
1. You can increase the LIMIT without breaking things. This might
increase speed for large batches.
2. If you want to have 2 (or more) sqlboxes, they can connect to the
same bearerbox without any problem. But yes, use a separate send_sms table
for each instance.
3. Adding the DELAYED option to the INSERT query might help. If it
does help, please post to the list. Possibly we can add it to the SVN
version of sqlbox.
4. Maybe the problem is not sqlbox itself, but your MySQL that takes
too long to process your queries. This goes beyond the scope of this
mailinglist but it is worth checking. From experience I know that running
the mysql databases on a solid state disk increases speed significantly.
== Rene
From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf
Of Eric Turner
Sent: Monday, 16 July, 2012 21:10
To: spameden
Cc: users
Subject: Re: sqlbox select speed
Sounds like it would be safer to have your application insert into two
different sqlbox tables and then have two different sqlbox instances feed
the same bearerbox.
On Mon, Jul 16, 2012 at 11:07 AM, spameden spame...@gmail.com wrote:
most likely you didn't optimize mysql
most work sqlbox is being done on INSERT rather than SELECT and DELETE, try
using INSERT DELAYED instead of INSERT in SQLBOX_MYSQL_INSERT_QUERY in
gw/sqlbox_mysql.h or optimize your MySQL setup.
try also to test kannel's speed without sqlbox involved at all without
database, might be a problem on your smsc operator side as well.
2012/7/16 Ashish Agarwal ashisha...@gmail.com
Hello Eric,
Sqlbox selects query uses limit 0,1 where it is selecting only one row at a
time. So running one more instance on the same database may duplicate the
record. Does it make sense to change the limit value and recompile sqlbox,
but I doubt this may not delete the row with relative sqlbox_id after
selecting.
On Jul 16, 2012 8:35 PM, Eric Turner e...@txtwire.com wrote:
I have never done it but I would guess that all you would need to do is
create a separate instance of sqlbox either on the same computer or a
separate computer what points to the same bearerbox.
Not sure if it is possible. Not sure how smart sqlbox is with two sqlboxes
reading out of the same table. If it isn't that smart you could have two
sqlboxes pointing at the same bearerbox but reading from different tables
and you make your application smart enough to put half of the messages in
one table and half in the other table. That should theoretically work get
two sqlboxes feeding the same bearerbox.
On Mon, Jul 16, 2012 at 8:37 AM, Ashish Agarwal ashisha...@gmail.com
wrote:
Hello Eric,
I think adding another sqlbox is a good option but how can I add another
sqlbox?
On Jul 16, 2012 6:37 PM, Eric Turner e...@txtwire.com wrote:
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
