Hi,
Many thanks. I tried and tested it. It works fine for small chunks of data
(I can see SMS going out of bbox in a sequence they were entered in
send_sms table). However, for large amount of data (e.g. I sent a bulk of
20k SMS via SQLBOX), it does not follow the same rule. Is it bearerbox
which
For priority I'd suggest adding a column called priority (typically
int(3) integer between 0 and 999) and doing ORDER by that column.
Do not forget to add an index as well or it might slow things down!
2013/11/12 ha...@aeon.pk ha...@aeon.pk:
Hi,
Many thanks. I tried and tested it. It works
Actually, if my understanding is correct (i.e. SQLBOX is already doing the
right thing by giving messages in FIFO order to bbox, but bbox is shuffling
the outgoing messages from within its buffer), then there is no point of
adding priority column.
What do you say?
On Tue, Nov 12, 2013 at 6:28
From: users [mailto:users-boun...@kannel.org] On Behalf Of ha...@aeon.pk
Sent: dinsdag 12 november 2013 15:28
To: spameden
Cc: kannel users
Subject: Re: SQLBOX working - LIFO or FIFO
Actually, if my understanding is correct (i.e. SQLBOX is already doing the
right thing by giving messages
To: ha...@aeon.pk; 'spameden'
Cc: 'kannel users'
Subject: RE: SQLBOX working - LIFO or FIFO
There's a 'priority' field in the Msg structure.
I think it serves for the purpose that you want to.
Just it's you cannot set it in the send_sms table. Not sure why, but
probably the field was added
*Sent:* dinsdag 12 november 2013 15:35
*To:* ha...@aeon.pk; 'spameden'
*Cc:* 'kannel users'
*Subject:* RE: SQLBOX working - LIFO or FIFO
There’s a ‘priority’ field in the Msg structure.
I think it serves for the purpose that you want to.
Just it’s you cannot set it in the send_sms table
...@aeon.pk [mailto:ha...@aeon.pk]
Sent: dinsdag 12 november 2013 15:51
To: Rene Kluwen
Cc: spameden; kannel users
Subject: Re: SQLBOX working - LIFO or FIFO
This is OK if SMSC does the re-ordering for congestion or some other
reasons. But my concern is that messages should at least leave bbox
:* dinsdag 12 november 2013 15:51
*To:* Rene Kluwen
*Cc:* spameden; kannel users
*Subject:* Re: SQLBOX working - LIFO or FIFO
This is OK if SMSC does the re-ordering for congestion or some other
reasons. But my concern is that messages should at least leave bbox in the
same order by which
*From:* ha...@aeon.pk [mailto:ha...@aeon.pk]
*Sent:* dinsdag 12 november 2013 15:51
*To:* Rene Kluwen
*Cc:* spameden; kannel users
*Subject:* Re: SQLBOX working - LIFO or FIFO
This is OK if SMSC does the re-ordering for congestion or some other
reasons. But my concern is that messages
: kannel users
Subject: Re: SQLBOX working - LIFO or FIFO
Yup, I have tried this already. But enabling DLR with remote SMSC comes at the
cost of reducing the overall SMS sending speed by half. Meaning, if I have a
bandwidth of 100 SMS/sec, enabling DLR will actually give me 50 SMS/sec
effective speed
Kluwen
Cc: kannel users
Subject: RE: SQLBOX working - LIFO or FIFO
20k SMS will take few seconds then why worry about the sequence since DLR is
not available and operator is not going to obey your sequnce/order at all.
Sent from Samsung Mobile
Original message
From: ha...@aeon.pk
since DLR
is not available and operator is not going to obey your sequnce/order at
all.
Sent from Samsung Mobile
Original message
From: ha...@aeon.pk
Date:12/11/2013 8:03 PM (GMT+05:00)
To: Rene Kluwen
Cc: kannel users
Subject: Re: SQLBOX working - LIFO or FIFO
Yup, I
/2013 8:03 PM (GMT+05:00)
To: Rene Kluwen
Cc: kannel users
Subject: Re: SQLBOX working - LIFO or FIFO
Yup, I have tried this already. But enabling DLR with remote SMSC comes at
the cost of reducing the overall SMS sending speed by half. Meaning, if I
have a bandwidth of 100 SMS/sec, enabling
Subject: Re: SQLBOX working - LIFO or FIFO
Yup, I have tried this already. But enabling DLR with remote SMSC comes
at
the cost of reducing the overall SMS sending speed by half. Meaning, if
I
have a bandwidth of 100 SMS/sec, enabling DLR will actually give me 50
SMS/sec effective speed
first, even when they
received message 1 first.
From: users [mailto:users-boun...@kannel.org] On Behalf Of Rene Kluwen
Sent: dinsdag 12 november 2013 15:35
To: ha...@aeon.pk; 'spameden'
Cc: 'kannel users'
Subject: RE: SQLBOX working - LIFO or FIFO
There’s a ‘priority’ field in the Msg
Yes you can do this.
Just alter gw/mysql_sqlbox.h and edit
#define SQLBOX_MYSQL_SELECT_QUERY
add there ORDER by sql_id ASC :)
2013/11/11 ha...@aeon.pk ha...@aeon.pk:
Hi,
Does SQLBOX work in LIFO or FIFO order? For me, it's working as LIFO which
is bad if I intend to send sequential message
16 matches
Mail list logo