[EMAIL PROTECTED] wrote: > I have a code (not mine) that work fine witout Apache:RegistryLoader > - problem is that every httpd process has ~30 MB. After using > Apache:RegistryLoader process is 5 MB + 20 MB in shared mem.
;) > But than new problem appered: when work without RegLoader I have > one connection do our Sybase database per process. Now I have only > ONE connection (database handle - $dbh - is global) within all > processes. I think this leads to my problem: database connection is > being corrupted after couple of minutes (Invalid packet header, > Unknown marker etc) > > Rewriting the could is rather not possible (~10.000 lines - not mine), > so I looking for some connection polling solution (or sth else). > > Does anybody could help me. sure, open the connection using connect_on_init() see http://perl.apache.org/guide/databases.html#Preopening_DBI_connections Also see a very nice article about Singletons in the perl review magazine vol 1 issue 0: theperlreview.com. _____________________________________________________________________ Stas Bekman JAm_pH -- Just Another mod_perl Hacker http://stason.org/ mod_perl Guide http://perl.apache.org/guide mailto:[EMAIL PROTECTED] http://ticketmaster.com http://apacheweek.com http://singlesheaven.com http://perl.apache.org http://perlmonth.com/
