Page 1 of 1

php mssql and ii6 very slow

Posted: Tue Apr 27, 2010 11:49 am
by sublimenal
Hi there I'm having very slow php /mssql transactions. Here is an example

http://areweontrak.com/tester.php

You can see making a query of even 1 row takes between 1.5 and 2 seconds which
is very long for a simple query. Has anyone had this problem before? Is there a way I could debug this? I have mssql server 2005 express, php5, ii6 installed.

When i make the same query with sql management studio it performs like it is suppose to, nice and fast.

Any help would be appreciated

Re: php mssql and ii6 very slow

Posted: Tue Apr 27, 2010 1:10 pm
by Benjamin
Your not using LAMP. You're using some strange blend of OS and Microsoft technologies. I wouldn't expect anything to work right with that sort of setup.

Re: php mssql and ii6 very slow

Posted: Tue Apr 27, 2010 2:57 pm
by AbraCadaver
sublimenal wrote:Hi there I'm having very slow php /mssql transactions. Here is an example

http://areweontrak.com/tester.php

You can see making a query of even 1 row takes between 1.5 and 2 seconds which
is very long for a simple query. Has anyone had this problem before? Is there a way I could debug this? I have mssql server 2005 express, php5, ii6 installed.

When i make the same query with sql management studio it performs like it is suppose to, nice and fast.

Any help would be appreciated
Hmm... I get this: 2 rows selected it took 0.003 seconds

Re: php mssql and ii6 very slow

Posted: Wed Apr 28, 2010 11:57 pm
by Brian Swan
Can you post more information about your configuration? If you are using FastCgi and the sqlsrv driver, you should not be seeing performance that is that slow.

Thanks.

-Brian