Re: [PATCH] PostgreSQL DLR speedup
Georg von Zezschwitz <[email protected]>
| Newsgroups | gmane.comp.mobile.kannel.devel |
|---|---|
| Message-ID | <[email protected]> |
Andreas Fink schrieb: > > This was not about LIMIT 1 (there was a reason for that) but about > doing DELETE and SELECT in one statement. > The LIMIT 1 was a workaround in the error of EMI protocol not giving > unique timestamps. > the timestamp on a SMSC is not unique, not even for one destination > number. Hi Andreas, I believe and observed the opposite. The SMSC increments the timestamp - even in the same second - if 2 messages are delivered to the same destination number within the same second. Are you really sure about this? Georg