Yes. I've been in contact with the SQL Relay author about
this exact topic. He was nice enough to add a C api so
that we could use it with vpopmail.
Unfortunately I haven't had any time to work on it.
Boris Mizhen wrote:
>
> Hello,
> 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*
> > Vpopmail with open ldap (server distant)
>
> Lets add:
>
> 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.
>
>
