I use a modified libsdb version that does not delete records once the
dlr comes in.

It works ok, but we have only a few hundreds/thousands of messages a
day. For each DLR call a new database connection is created, which is
very inefficient.

Really, the best way of using postgres would be to use the new sqlbox
and instead of having a standard sql statement, use a postgres stored
procedure with some custom triggers in the database. As you probably
know, query plans for stored procedures are cached, so they are very
very fast.

Rory

On 08/06/04, Guillaume Cottenceau ([EMAIL PROTECTED]) wrote:
> There is no native PostgreSQL driver in Kannel. However, it is
> supported via libsdb, since some time now.
-- 
Rory Campbell-Lange 
<[EMAIL PROTECTED]>
<www.campbell-lange.net>

Reply via email to