Jump to content

Archived

This topic is now archived and is closed to further replies.

belick

mssql_query is very slow

Recommended Posts

I am using mssql_query() and its very slow. I tested the connection with a remote software and I was able to get and update the information very fast, but when I use the PHP mssql_query function its very slow... any help to find the problem will be very helpful.

Thanks

Share this post


Link to post
Share on other sites
Does your php code go something like this?
[code]
connect
query
disconnect

connect
query
disconnect
[/code]

Share this post


Link to post
Share on other sites
I am also the same problem happen. I called using store procedure in my PHP but most of the time, timeout. I called the same storeprocedure in my SQL Query Analyser. Response time is less than 1s.

Is there any problem with my webserver or my SQL 2000 server or my Network?
Did you solve your problem, belick? Can share with me?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.