> Hello, > > I have been using mysql_connect in a script that display a lot of thumbnails > for an album. Each thumbnail is displayed using the code: > > <IMG SRC="thm.php?id=some_id ALT="some title"> > > thm.php use a mysql_connect to the database to access the info about the > picture based on the id. > > This worked fine. However, the SQL server is located on a different network > than the web-server with a firewall between. When I looked into the firewalls > log I saw that there was large amount of new connections when someone > accessed the page where all the thumbnails was displayed. > > I then changed mysql_connect to mysql_pconnect on the scripts and viola... the > amount of new connections to the SQL server dropped to only two. > > Good, I thought. But later I discovered that the SQL server had a large amount > of childs running. I had 50-60 mysqld running on the system. This number was > constant to below 10 before I changed to persistent mode. > > Any settings in the config file for the sql-server I need to be aware of? > > I'm using MyISAM tables .
I would have to say, this is suboptimal, and perhaps a little OT, but here goes. If you have 50 images, you are going to make 50 selects to your database, depending on how you connect, you may make 50 connections, or not. What you should do, is grab the 50 images ahead of time, in one select, and use some php to iterate them and display them. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
