Jump to content


Photo

mssql_query is very slow


  • Please log in to reply
2 replies to this topic

#1 belick

belick
  • Members
  • PipPipPip
  • Advanced Member
  • 60 posts

Posted 14 August 2006 - 09:39 PM

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
<?="C"+"Y"+"T"+"N"+"E"+"T"+"."+"C"+"O"+"M";?>
Cytnet.com :-)

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 19 August 2006 - 01:58 PM

Does your php code go something like this?
connect
query
disconnect

connect
query
disconnect

If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#3 wint.thaw

wint.thaw
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 05 June 2007 - 08:14 AM

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?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users