Re: [Announce] New Sqlbox version

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