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