Re: Questions..

> We are using PHP on a large scale website, with mysql. THis site is clustered, > and we are trying to figure out a way to minimize the number of connections to > the database. Using pconnect with both the shared and static apache options we > end up having one connection to the db per server. Since new apaches spawn as > time goes on, it means we get between 100 - 200 connections at a given time. > We need to minimize that number. You can use mysql_connect (no 'p') then only when your code needs it, will there be a connection to your DB from that apache thread. On another note, you can also do some tuning to your mysql server. In your my.cnf file, specifically, you can modify your max_connections and connect_timeout. -jeremy brand _______________________________________________________________________ GnuPG Fingerprint: 9F5E 95E0 1CC2 E054 84EA 6099 8ACD 9DBA D2C0 5EA9 _ http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for more __