Hey I have been trying to optimize my mod-perl scripts, by following some of the instructions at http://perl.apache.org/guide/performance.html. I have added my mod-perl modules to my startup.pl file for Apache - along with usual stuff and CGI, Apache::DBI and DBI->install_driver("mysql"); When I stop-start apache, i get the following entries in the mysql log: 842 Connect root@localhost on server101 842 Quit 843 Connect root@localhost on server101 843 Quit 844 Connect root@localhost on server101 844 Quit .... and on, it just keeps repeating until i kill apache again. What should i be looking for in my modperl modules that would cause this? I originally had DBI->connect functions in each module, but since they should now all be loaded at startup, i thought only one connect would suffice, but that does not work either ( I get "cannot perform prepare_cached on an undefined object"). What am i missing here? Am i a mile off?? Should the modules be included in the startup.pl file? It did seem to help the difference between memory size and shared memory size. Thanks for your help Regards, ___________ Steven Wren [EMAIL PROTECTED] http://www.server101.com Webhosting and E-commerce Solutions The world is not only stranger than we suppose, it is stranger than we can suppose. -J.B.S. Haldane
