RE: [PATCH] PostgreSQL DLR speedup

Andreas Fink wrote:
>>> 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
> 
> not on a standard CMG SMSC.

I remember ages ago having this conversation with a European carrier who use
standard CMG SMSC & they told me that their SMSC will increment the
timestamp by 1 second if there are 2 msgs in the same second for the same
handset.

> This was an issue with multipart long text message which got
> sent the same second usually with same SMSC and same
> destination number. Both part ended up with the same
> timestamp. So the LIMIT 1 was added so it considers ONE of
> them delivered when ONE delivery report came in. It MIGHT be
> the wrong one but at leas the COUNT was right. Still better
> than to acknowledge both part delivered when only one was.



-- 
Ian Cass