Re: RE: [PHP-WIN] mssql and php4

Hi Kelvin, Check the connection from your computer to the server using Query Analyzer if the connection is still slow it is some kind of network problem. If not it must be the PHP installation. Have you checked your php.ini for loading extensions you are not using ? This would affect the CGI version as extensions are loaded on each request. You could also add som debug information like this: $ts = time(); mssql_function(); $ts1 = time(); exho "execution time = " . ($ts1 - $ts) . "<br>"; This way you can find out what function is responsible for the long respose time. With small tables MySQL and MSSQL gives the same performece but with large tables and complex SQL statements MSSQL is the fastes, so it will not help switching database (unless proce is an issue) - Frank > Hi, > Thanks for the suggestions. I've tried installing PHP and Apache on a > collegues machine and running the same code and it runs much much much > faster! Their processor is only a little faster than mine so I think that > something must just have gone wrong with my installation. I have tried > reinstalling both PHP and Apache on my machine, replacing all the dll's etc > but it still runs slowly from my machine. It's not too much of a problem > though because I now know the code will be fast enough in a production > environment and I can deal with the slowness while I develop or use someone > elses machine... > Thanks for all the help, > Kelvin. > > -----Original Message----- > From: joel@intwebservices.com [mailto:joel@intwebservices.com] > Sent: 18 April 2001 15:18 > To: Kelvin Luck > Cc: php-windows@lists.php.net > Subject: Re: [PHP-WIN] mssql and php4 > > > >Any other ideas? > > Other factors that could affect performance would be: > Is your table indexed? > How big the database is. > How complex is the query in "mssql_query($getArticlesSQL)" > Server cpu load. > > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >