Is there anyway to ensure a database handle is not being used by more than one process on the machine at one time without developing one's own locking mechanisms?
We want to limit the number of connections to our database. If the same .epl page is being hit 50 times simultaneously, we risk an attempt of 50 simultaneous database connections... which is too many.
I am using DBIx::Recordset and can check $DBIx::Recordset::numOpen for the number of open database connections, but, under mod_perl with Embperl $numOpen will not vary if the same open handle is being used by more than one process... or am I mistaken?
Terrence Brannon
90 St. Mark's Place
Apt. 2E North
Staten Island, NY 10301
914-755-4360
---------------------------------
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
We want to limit the number of connections to our database. If the same .epl page is being hit 50 times simultaneously, we risk an attempt of 50 simultaneous database connections... which is too many.
I am using DBIx::Recordset and can check $DBIx::Recordset::numOpen for the number of open database connections, but, under mod_perl with Embperl $numOpen will not vary if the same open handle is being used by more than one process... or am I mistaken?
Terrence Brannon
90 St. Mark's Place
Apt. 2E North
Staten Island, NY 10301
914-755-4360
---------------------------------
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!