Re: sqlbox kannel and scheduling

right now if u want scheduling u got to do it on the app side

i'm not sure it would be a good idea to put it into sqlbox..
sqlbox job is sending the messages, any scheduling u may want to do
can be easily done on your app, with schedules tables, and a cronjob
that reads them and feeds into sqlbox when needed


On Tue, Mar 4, 2008 at 4:18 PM, Alejandro Guerrieri
<[email protected]> wrote:
> sqlbox sits inbetween smsbox and bearerbox, and catches all traffic going in
> and out. If you queue a message using the HTTP interface on smsbox, it will
> overgone the same DLR methods as before (if you use sql storage it will
> write an entry there and wait for the answer to update it).
>
> I'm not sure about MT enqueuing directly on sqlbox, never tried it that way
> with DLR's.
>
> Regarding scheduling, that would require a "WHERE" on the sql (eg, compare
> the "time" field with the local timestamp and only select messages where
> time >= timestamp). The way it is now (one query per message) could be
> overkill on large volumes, but with the patch for group selects and adding
> an index on the field could be easily implemented.
>
> Regards,
>
> Alejandro
>
>
>
> On Tue, Mar 4, 2008 at 3:52 PM, akif dinc <[email protected]> wrote:
> >
> >
> > the idea with scheduling was having the message send at a given time/date.
> like send message on the 12. of october 2008.
> > also one question i would like to ask is if how to find the relation
> between the sent message and the delivery report to it. i've a smpp
> connection and use sqlbox, it works for testing at the moment very well.
> before using sqlbox i updated via a self written php file a databasetable
> with the delivery report status.
> > after using sqlbox do i have to keep track of the send messages or can
> sqlbox somehow do this for me?
> > i wonder if there is still need for futher db tables or if i can handle
> all with the existing sent_sms. where my needs would be restricted to know
> what status the message at the moment has (like delivered, pending, etc.)
> >
> > thank you very much in advance,
> >
> >
> > ________________________________
> Date: Tue, 4 Mar 2008 12:26:34 -0200
> > From: [email protected]
> > To: [email protected]
> > Subject: Re: sqlbox kannel and scheduling
> >
> >
> >
> >
> > >From what I've learned from the source code, no, sqlbox reads messages
> one by one (I've made a patch to retrieve batches of messages) without any
> kind of sorting or scheduling.
> >
> > So, if you insert 100K messages at once, they will be retrieved one by one
> and not necessarily on the same order of insertion.
> >
> > The only scheduling you'll get is when messages are on the kannel's store
> (that's when sqlbox insert the messages to bearerbox).
> >
> > Hope it helps,
> >
> > Alejandro
> >
> >
> > 2008/3/4 akif dinc <[email protected]>:
> >
> >
> > hello,
> >
> > does sqlbox support sheduling?
> >
> >
> >
> >
> > ________________________________
> Direkter Zugriff zu Hotmail und Messenger! Kostenloses Update für Ihren
> Internet Explorer!
> >
> >
> > --
> > Alejandro Guerrieri
> > Magicom
> > http://www.magicom-bcn.net/
> > LinkedIn: http://www.linkedin.com/in/aguerrieri
> > ________________________________
> Mit Live Search: Ihre Stadt in der Vogelperspektive! Erleben Sie neue
> Blickwinkel!
>
>
>
> --
> Alejandro Guerrieri
> Magicom
> http://www.magicom-bcn.net/
> LinkedIn: http://www.linkedin.com/in/aguerrieri