Hi Waynn!
have you ever tried using
1. sql_cache
SELECT SQL_CACHE * FROM table ..
I use this alot... although you have to have mysql cache enable in the
sql config file... your webhost can tell you if it is on or not
2. make indexes for your tables
here is a good article
http://www.databas
Waynn Lue wrote:
Our site has been slowing down dramatically in the last few days, so
I've been trying to figure out why. I ran some profiling scripts on
our site and saw that we're spending between 3-9 seconds on
mysql_connect. Then I connected to our db and saw that there were
over 100 connec
Waynn Lue wrote:
Our site has been slowing down dramatically in the last few days, so
I've been trying to figure out why. I ran some profiling scripts on
our site and saw that we're spending between 3-9 seconds on
mysql_connect. Then I connected to our db and saw that there were
over 100 connec
Our site has been slowing down dramatically in the last few days, so
I've been trying to figure out why. I ran some profiling scripts on
our site and saw that we're spending between 3-9 seconds on
mysql_connect. Then I connected to our db and saw that there were
over 100 connections at the time,
4 matches
Mail list logo
