; 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:
There’s no absolute need for two smsboxes to be connected
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
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
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
Doesn't 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
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.comwrote:
Hello,
With sqlbox I have around 15,00,000 number of record in
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
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
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
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
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
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
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
13 matches
Mail list logo