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
php mssql and ii6 very slow
Moderator: General Moderators
-
sublimenal
- Forum Newbie
- Posts: 23
- Joined: Sun May 16, 2004 2:17 pm
- Location: Massachusetts
Re: php mssql and ii6 very slow
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.
- 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
Hmm... I get this: 2 rows selected it took 0.003 secondssublimenal 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
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
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
Thanks.
-Brian