Re: TOO MANY CONNECTIONS!!

Helo, why you don't make some kind of "db_connect.php" which will make "mysql_pconnect()" and include it in top of your first script? You then will be able use mysql query in everyone of your page. You can also make $mysql_is_connected=true; there and check that variable in other scrips if need to be sure that this file was already included. -- Regards, A.K. "Georgie Casey" <webmaster@filmfind.tv> wrote in message news:20021024201835.36082.qmail@pb1.pair.com... > Yeah, sometimes I open and close 2 or 3 permanent connections in one page. I > knida have to as each page is made up of a few different include files, and > if I dont do seperate connections, it mightnt work. > > I'll recode my site to cache everything except search pages, or can I even > cache these as well?? > "Duncan Hill" <dhill@cricalix.net> wrote in message > news:20021023222841.GD30375@bajan.cricalix.net... > > On Wed, Oct 23, 2002 at 10:18:07PM +0100, Georgie Casey wrote: > > > Im getting a too many connections error in my PHP pages at > > > http://www.free-ringtones.tv. I presume this is from the MySQL server, > and I > > > know I access the database a lot for each page. So whats the solution to > > > > MySQL has a default of either 50 or 100 concurrent connections. Exceed it > > and you'll get that error. That parameter is configurable - if you run > the > > MySQL daemon itself. If you use shared hosting, you may not be able to > > tweak it. > > > > Do the pages -need- to be totally dynamic, or can you use the caching > system > > you mentioned? If so, then wrap code that stats an HTML page for the > time, > > and if it's too old, update it. Be sure to use file locking so you don't > > clobber yourself. > > > > Moreover, do you open one connection and re-use it in a page, or do you do > > multiple opens and closes? > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >