forward a question of my college. bet someone can help. Thanks. -------- Original Message -------- Subject: what is the relationship between nubmer of dbh and concurrent web user in catalyst? Date: Mon, 11 Sep 2006 18:55:47 +0800 From: chylli <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED]
Hi,all We have an app and use dbic in catalyst. App will initialize every dbic when apache startup. My question is , if we have many users at the same time, say, 1000 users view our web, will apache create new sub process and init all dbics again ? How many connections with mysql will it create? Are there a formula between number of connection with mysql and concurrent users ? I remember it seems that every five sub process ( thread ?) share one dbh in mod_perl, but I'm not sure. Can anyone give me a more accurate formula ? In apache manual, it is said that when you use Apache::DBI before any thing like DBI, you can get persistent connection to mysql. But I'm not using Apache::DBI and it seems like I got persistent connection because there are lots of connection even there are very few users. How should I get non-persistent connection? And, I have several database and want to make persistent connection on some dbs and non-persistent connection on others. What should I do ? -- Thanks & Regards Chylli _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
