Re: MySQL DLR
Andreas Fink <[email protected]>
| Newsgroups | gmane.comp.mobile.kannel.devel |
|---|---|
| Message-ID | <p05101502b8ddd983b202@[10.0.0.2]> |
>Hi Andreas, > >> For those of you who use mysql delivery reports, here's the >> definition of the standard table. I added indexes to this as >> otherwhise your system becomes suddendly very slow if you forget >> them. Happened to me with 80'000 records in the DLR database the >> speed was dropping to 3-4msg/sec where it should be 15-20msg sec. So >> if you havnt thought of indexes in the DLR table, add them. It makes >> a big difference! > >yep, definitly. > >Maybe we should add this to the MySQL related DLR section in the >user's guide?! > Good idea. I'm working on a final fix for the non-unique timestamp problem in DLR with EMI/UCP and I'm 80% done. This also introduces a new field in the MySQL table to uniquely identify a record (primary key id) so I will update it at the same time. -- Andreas Fink Fink-Consulting ------------------------------------------------------------------ Tel: +41-61-6932730 Fax: +41-61-6932729 Mobile: +41-79-2457333 Address: A. Fink, Schwarzwaldallee 16, 4058 Basel, Switzerland E-Mail: [email protected] Homepage: http://www.finkconsulting.com ------------------------------------------------------------------ Something urgent? Try http://www.smsrelay.com/ Nickname afink