Re: MySQL DLR

Stipe Tolj <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Organization Wapme Systems AG
Message-ID <[email protected]>
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?!

Stipe

[email protected]
-------------------------------------------------------------------
Wapme Systems AG

Münsterstr. 248
40470 Düsseldorf

Tel: +49-211-74845-0
Fax: +49-211-74845-299

E-Mail: [email protected]
Internet: http://www.wapme-systems.de
-------------------------------------------------------------------
wapme.net - wherever you are
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.