Alex,
The deferred field does get processed and afaik it's passed on the
SMPP link (as long as the SMSC supports it) so I'd rather don't touch
it either :)
Regards,
Alejandro
El 18/11/2008, a las 01:54 p.m., Alexander Malysh escribió:
Hi,
there is deferred filed in kannel Msg struct, that could be used for
this...
Alejandro Guerrieri schrieb:
I think that having scheduling capabilities would be cool, but I
definitely do not agree with using the time column, since that
column is used internally on Kannel and cannot be tweaked without
disrupting other stuff.
I think this needs further thinking, though. There are performance
considerations to take into account for example (when you have lots
of messages queued, adding a condition on the select can impact
performance if it's not done right).
Regards,
Alejandro Guerrieri
El 18/11/2008, a las 12:36 p.m., Ehizogie Binitie escribió:
Hi Alex
What are your thoughts on converting the timestamp on the sqlbox
field
into a basic scheduler.
So messages are delivered if system time greater = or > msg time
stamp?
Ehi
On Tue, 2008-11-18 at 10:15 -0200, Alejandro Guerrieri wrote:
Ken,
I've used SqlBox to handle 200-300K messages per day for months
with
no issues using commodity hardware (P IV 3.0 Ghz with 1 Gig RAM)
and
using the same box for kannel, sqlbox and MySQL. The traffic was
unevenly distributed across the day, with day hours receiving
almost
all traffic.
I think Sqlbox can handle that load on decent hardware. You'll
have to
take into account other factors though, specially on the
application's
side, as well as the SMPP traffic to your carrier.
Regards,
Alejandro Guerrieri
El 18/11/2008, a las 09:46 a.m., Ken Bellars escribió:
Hi Alejandro,
Your contributions are highly appreciated.
Am about to use SQLbox for a production system for delivering
5million
sms/monthly. please can SQLbox handle this seamlessly?
I anticipate your early reply.
On 11/18/08, Alejandro Guerrieri <[EMAIL PROTECTED]> wrote:
Hi,
I've just commited a new SqlBox version. Changes on this
version are:
- Added support for the LibSDB database abstraction library. DB
support is now similar to Kannel's.
- Extensive code reorganization to move the queries into the
header
files and allow reusing from the libsdb module.
- Added examples for database connections on sample conf file.
I've also started a numbering schema and I'm also tagging
relevant
versions.
Cvs version 20081103 is now tagged as rev-0-6-0 and represents
Sqlbox-0.6.0.
Cvs version 20081113 is now tagged as rev-0-7-0.
Cvs version 20081118 is now tagged as rev-0.7.1 (This is the
latest
release).
As usual, you can checkout latest version from CVS, and also
retrieve
tagged versions as follow:
cvs co -r rev-0-6-0 (to retrieve version 0.6.0, for example).
You can also download this and former releases from here:
http://www.kannel.org/~aguerrieri/
Regards,
Alejandro Guerrieri
--
Regards,
Kenny
"Whosoever desires constant success must change his conduct with
the
times."-Niccolo Machiavelli