Re: PHP and MS SQL 2000 Performance

First, are you using the mssql.dll to connect or ODBC? Using mssql.dll Second, are you running PHP as a cgi or ISAPI plug-in? As a CGI under the "Home Directory" tab Third, is performance from an ODBC client and/or remote Query Analyzer client slow performing the same queries? Performance from the Query Analyzer is extremely fast - pulls up 2000 records in like 3 seconds. Fourth, did you check your SQL Server box and look at the activity on it? Is SQL Server or some other service hogging resources? SQL Server is taking up about 40MB of memory, but not much of anything else going on. Thanks, Michael Thanks, Joshua Hoover > We're only running one database on the system. The sample databases that > come with the software are still on there, but they're not being used at > all - this system is still in the testing stage. We're running an > Athlon > 1.2 GHz processor with 512 MB RAM. > > "Gadam" <gadam@arkonet.gr> wrote in message > news:001c01c170b4$266aeb50$0100a8c0@fintani... > 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 > > > > -- > 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 > >