php mssql and ii6 very slow

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
sublimenal
Forum Newbie
Posts: 23
Joined: Sun May 16, 2004 2:17 pm
Location: Massachusetts

php mssql and ii6 very slow

Post 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
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: php mssql and ii6 very slow

Post 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.
User avatar
AbraCadaver
DevNet Master
Posts: 2572
Joined: Mon Feb 24, 2003 10:12 am
Location: The Republic of Texas
Contact:

Re: php mssql and ii6 very slow

Post 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
mysql_function(): WARNING: This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQLextension should be used. See also MySQL: choosing an API guide and related FAQ for more information.
Brian Swan
Forum Newbie
Posts: 17
Joined: Thu Jan 14, 2010 11:56 am

Re: php mssql and ii6 very slow

Post 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
Post Reply