Hi,
I was all happy and rolling along when I read this in the docs.
"With this limitation in mind, there are scenarios, where
the usage of Apache::DBI is depreciated. Think about a
heavy loaded Web-site where every user connects to the
database with a unique userid. Every server would create
many database handles each of which spawning a new backend
process. In a short time this would kill the web server."
I will have many different users, users as in database users. So am I just
screwed and won't be able to keep connections open?
Or maybe the idea would be to go ahead and let that happen, but timeout the
connection in 5 mintues or so? That way I wouldn't have open connectoins
from user bob from 5 hours ago still siting around. Or am I totaly not
getting it at all?
I am using Postgress, I am wondering how big DBs deal with this sort of
thing. I am also wondering what the actual overhead is in starting the
connection and if there is anything that I could to to limit that without
validating a specific user.
Last of all, I might not be posting this to the right place, but I hope so.
It seems to me there is a grey area when it comes to Apache modules when you
are using them with mod_perl. Or else I just don't know enough yet to see
there is not a grey area :)
Thanks,
Eric
http://www.kwinternet.com/eric
(250) 655 - 9513 (PST Time Zone)
