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