This is a very important topic...
I believe that the a lot of performance loss with any database
comes from the fact
that you open a new db connection every time you need to access data.
Here i believe is a solution that might speed things up dramatically:
I requires some patches to Vpopmail
From freshmeat:
----------------------------------------------------------------------------------------
application: SQL Relay 0.13
author: David Muse <[EMAIL PROTECTED]>
license: GPL
category: Daemons/Database
urgency: low
homepage: http://freshmeat.net/redir/homepage/954872796/
download: http://freshmeat.net/redir/download/954872796/
description:
SQL Relay is a set of daemons and clients with C, C++, and Perl APIs
for maintaining persistant connections to Oracle, MySQL, mSQL,
PostgreSQL, SQLite, and Lago databases and executing queries through
those connections. It is especially useful for speeding up Web-based
applications which would otherwise be written using the database APIs
or Oracle Pro C.
Changes:
Fixes for some bash/sh build problems.
> http://freshmeat.net/news/2000/06/14/961022025.html
-------------------------------------------------------------------------------------------
*Configurations*Lets add:
Vpopmail with open ldap (server distant)
Vpopmail with SQLRealy local, Db server local
Vpopmail with SQLRealy local, Db server distant
-- Your computer does what you tell it to do, not what you want it to do.
