Hi,
There are 2 possible DB uses for kannel:
1) DLR processing (internal)
2) Final DLR message (your application - optional. Read UG about dlr-url)
Indexes for (2) are your responsibility, depending on how you design your
app.
Indexes for (1) can be:
A) smsc-id and ts (and if using a lot of EMI or CIMD smscs, 7 last digits of
destination number)
B) timestamp (if not using EMI or CIMD)
timestamp should be your own column, not described in the manual. It is
useful for deleteing stale DLRs. It should be automatically generated by the
database. For EMI or CIMD smscs, you can use ts for that.
BR,
Nikos
----- Original Message -----
From: "Richard Crawshaw" <[email protected]>
To: "Nikos Balkanas" <[email protected]>; "Mohammed Saleem"
<[email protected]>
Cc: <[email protected]>
Sent: Wednesday, June 01, 2011 5:36 PM
Subject: RE: Pointers for best DLR performance
Nikos, Mohammed
Many thanks for the information, that was just what I was after.
We're going for a new database on an existing instance of SQL Server running
on separate hardware. I'm thinking that we might need to beef-up the
virtual hardware of the Kannel Ubuntu machine. I'll try to remember to post
about progress in a little while.
On a connected matter, what indexes might be useful on the dlr table? I'm
guessing the smsc-field as that would appear to contain the foreign id as
generated by the SMSC.
Regards
Richard
PS, Sorry Nikos, my last reply was intended to be to the list, not just to
you. We've changed company name, and email addresses, so the list rejected
my email and it's all gone downhill since then...
-----Original Message-----
From: Nikos Balkanas [mailto:[email protected]]
Sent: 01 June 2011 00:46
To: Mohammed Saleem; Richard Crawshaw
Cc: [email protected]
Subject: Re: Pointers for best DLR performance
Not quite. Benchmarks with fakesmpp using a native middle-end Solaris 10
(64bit) have shown ~750 MT/s when using internal DLRs and ~450 MT/s when
using mysql. You can serach the email archives for the detailed benchmarks.
Using a visrtual machine is always a bad choice if you seek performance. If
you must have kannel on such a machine, better use a different one for the
DB, especially if you are using DB for DLR processing.
Regards,
Richard Crawshaw
Software Developer
Contact Group
Telephone (UK): 0844 448 442
Telephone (ROI): 0818 286 795
Mobile : 0786 625 9418
Direct Facsimile: 0844 448 9090
Email: [email protected]
Web Site: http://www.contactgroup.com/
This e-mail is intended for the above named only. It may contain private and
confidential information or material that is
privileged. If it has come to you in error you must take no action based
upon it, nor must you copy or show it to anyone.
Please return the message immediately to [email protected]
The Validity of any pricing information contained herein is 30 days unless
otherwise stated. E & OE. Standard
terms and conditions apply. Service by Contact Group. Registered in England
No. 4125665. Registered office:
Lonsdale House, 52 Blucher Street, Birmingham, B1 1QU. Data Protection No.
Z7911829
