>>If you put a dbh->prepare statement immediately before each execute(), it >>should work...bearing in mind that I >>haven't been able to test this.
> Only advantage gained here is the persistant connection, as the prep > statements (or prep_cached) seem to have their own large overheads.. So write a new connect_cached() which also re-prepares the statements on a reconnect... Alternatively, have filter_tick defined, and make it run a query on the database, then configure the multiplexor to use the tick function, which will stop the connection timeout. Paul. -- ------------------------------------------------------- Paul Murphy Head of I.T. Argenta Discovery Tel. 01279 645 554 Fax. 01279 645 646 _______________________________________________ NOTE: If there is a disclaimer or other legal boilerplate in the above message, it is NULL AND VOID. You may ignore it. Visit http://www.mimedefang.org and http://www.roaringpenguin.com MIMEDefang mailing list [email protected] http://lists.roaringpenguin.com/mailman/listinfo/mimedefang
