Re: [Announce] New Sqlbox version

Hi Alejandro,

Is there any hope of having this scheduling capabilities in the SQLBox in
the nearest future ?

--
Kenny

p: +2348034939090
e: [email protected]
w: www.nuObjects.com

Bulk SMS Solutions | Managed Hosting | Enterprise Application Development


On Tue, Nov 18, 2008 at 5:02 PM, Alejandro Guerrieri
<[email protected]>wrote:

> 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/<http://www.kannel.org/%7Eaguerrieri/>
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> Alejandro Guerrieri
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> Regards,
>>>>>> Kenny
>>>>>>
>>>>>>
>>>>>> "Whosoever desires constant success must change his conduct with the
>>>>>> times."-Niccolo Machiavelli
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>
>>
>
>