[PHP-DB] Slowing right down... From: Graham Brown (gbrown <email protected>)
Date: 10/12/01

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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>