Sorry for the double post.
Another option for you is use 2 separate sqlbox instances, one for each campaign. == Rene From: Rene Kluwen [mailto:[email protected]] Sent: Sunday, 05 February, 2012 16:54 To: 'Suranga Ranjith'; '[email protected]' Subject: RE: Give Priorities for send_sms table messages Sqlbox sends out the messages in the order it gets them from the select statement. If you want to implement priorities, modify the select statement with an "order by" clause. This is not recommended though, as it hits a performance penalty. == Rene From: [email protected] [mailto:[email protected]] On Behalf Of Suranga Ranjith Sent: Sunday, 05 February, 2012 06:08 To: [email protected] Subject: Give Priorities for send_sms table messages Hi all, I'm sending out sms from sqlbox. So usually I put 1000 messages into the send_sms table. For instance assume I have 2 kind of campaigns and each has 10000 messages to send. So I first add first 10000 messages from campaign_1 to the send_sms table and after 2,3 seconds I push my next campaign to send_sms table. Does sqlbox pop ot those messages from send_sms table in a random way or a kind of round robin? Can we set a priority for those messages? What I want is to give same priority (or as a rate) for both those campaigns, even one starts several minutes/seconds after the other. Best Regards, Suranga.
