Re: TOO MANY CONNECTIONS!!

Just open one connection. It'll work fine for multiple queries across several include files. I have a project right now that uses about 5 different include files at any one time, and 1 connection works great. Also keeping only one connection alive will speed up the script. -Micah At 09:14 PM 10/24/2002 +0100, Georgie Casey wrote:

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