Re: [Announce] New Sqlbox version

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
>>
>>
>
>