Re: [Exim] How to: exim + Oracle + Perl + DBI

On Wed, 25 Jul 2001 14:57:13 +0100 (BST), you wrote:

>On Tue, 24 Jul 2001, Paul Kelly wrote:
>
>> I had a go at writing a C based oracle OCI exim lookup a few months ago
>> with std exim connection caching like the mysql/postgresql lookups,
>> hopefully phil will integrate it within exim 4.
>
>I have recently done so.
>
>The problem with all these database lookups is that Exim's design does not
>make it possible to use the database in an efficient manner. Each Exim
>process that issues a query has to set up a new connection to the
>database, do the lookup, and tear down the connection again. It is not
>possible to retain the connection over long periods, nor is it possible
>to prepare the query once, and re-use it again and again and again.

the correct solution, then, would seem to be to build a standalone
"exim database listener" process which maintains the connection, and
takes the queries from exim.

it's a design i've used before when presented with similar situations.

richard