Re: [Announce] New Sqlbox version

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