[EMAIL PROTECTED] said: > Can anyone show me a sample of connection caching for "use DBI;" within > cgi/mod_perl? Currently, I am using "use DBI;" not Apache::DBI because I > can't get Apache::DBI to work.
I'm not entirely sure what you mean by "connection caching", but I think I might have an answer for you. I wrote a small Perl script daemon to pool 10 database handles at a time. It will grow to 15 if it needs, and after an hour of not using more than 10, it will shrink the pool back down to 10 handles. In order for any other Perl script to retrieve a handle from the pool, it just has to access a (well-secured) UNIX socket and request one. When it's done with the handle, it accesses the socket again and releases it. By pooling database handles this way, I don't have to take the 900ms to connect to my two databases every time my script runs. Anyway, I think that's roughly what you mean. Colin -- Colin W. Wetherbee http://hydrogen.denterprises.org/
