Dave Jong A Lock schrieb:
Dear friends,
Now I'm pretty much sure my db is the reason of my slow responses (sometimes
up to 2 hours delay), in the end resulting in other errors. The db isn't
really big in other terms (only 200mb). But the performance is the issue,
how can I change settings for my db or should I change my perl application?
1) are you indexing the search attributes? Make sure that you have a defined
index, so DLR lookups are fast.
2) Kannel does NOT maintain the table. In case DLR temp data are stored, and
bearerbox never receives DLRs, it will never DELETE the entries. You need to
take care of it, otherwise things grow.
If you don't manage 1)+2) then you result in a growing table space and the
sequential lookups take more and more time.
Stipe
-------------------------------------------------------------------
Kölner Landstrasse 419
40589 Düsseldorf, NRW, Germany
tolj.org system architecture Kannel Software Foundation (KSF)
http://www.tolj.org/ http://www.kannel.org/
mailto:st_{at}_tolj.org mailto:stolj_{at}_kannel.org
-------------------------------------------------------------------
