Slowing right down...
| From: | Graham Brown | Date: | Fri, 12 Oct 2001 12:31:37 +0000 |
| Subject: | Slowing right down... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13291@lists.php.net to get a copy of this message | ||
I'm running a sight using PHP4x and MySQL database. I'm using the PCONNECT
command as the site
has one connection to the database and multiple users (diff user/passwords
for each account).
The site either runs fast or slows right down (even stops) when other users
come online.
How can I optimise this ? (NB no access to PHP or MySQL config files).
* Do I continue with MYSQL_PCONNECT or MYSQL_CONNECT ?
* Will commands such as FREE RESULT help with speed ?
The site is accessing the database many times (I have indexed all nec.
fields) and I feel it is
probably an expensive load on the server. Any suggestions?
Many thanks in advance
Graham