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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 18 April 2001 15:18
> To: Kelvin Luck
> Cc: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
