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

Páxina inicial
Borrar esta mensaxe
Responder a esta mensaxe
Autor: Philip Hazel
Data:  
Para: Paul Kelly
CC: Paul Makepeace, exim-users, Chris Lightfoot
Asunto: Re: [Exim] How to: exim + Oracle + Perl + DBI
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.

-- 
Philip Hazel            University of Cambridge Computing Service,
ph10@???      Cambridge, England. Phone: +44 1223 334714.