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.