RE: [PHP-DB] PHP and MS SQL 2000 Performance

MS SQL has generally very slow performance and is consuming a lot of system resources. Are you running any other databases on the SQL server, apart from the one you are querying? Could it be that your system has very small processing power? In any case, these possibilities wouldn't justify suck a long delay, unless you SQL server is "overcrowded" with other huge databases that you use... George -----Original Message----- From: Michael Kroiss [mailto:michaelk@worldnet.att.net] Sent: Monday, November 19, 2001 3:30 PM To: php-db@lists.php.net Subject: [PHP-DB] PHP and MS SQL 2000 Performance We're running W2K, IIS 5, PHP 4, and SQL Server 2000 and performance seems to be really slow. We're using a simple connect PHP script to query a table that has only 1 record in it, and it takes approximately 20 seconds to load. This seems to be very slow. Is this normal or does anyone have suggestions how to speed things up? Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net