Jump to content


Photo

mySQL versus MS SQL


  • Please log in to reply
1 reply to this topic

#1 matte

matte
  • Members
  • PipPip
  • Member
  • 14 posts

Posted 06 September 2006 - 02:42 PM

not sure if this is the correct place to ask this  but here goes...

i have been developing a content mangament system that will run with both mysql and ms sql.  I developed the site on apache w/ mysql server and it runs fine.  Now i moved to over to IIS 6 with MS SQL and it runs terribly slow.  Most of the time i get timeout error loading a page.  I have went back through the code and checked for anything that could cause it and haven't found anything. 

I have tried it on 3 different IIS 6 servers with the same MS SQL database and they are all just as slow.  I guess my question is would it seems resonable to assume that MS SQL is a considerable amount slower than mySQL?  Does anyone know anything else i could try?


#2 chernyshevsky

chernyshevsky
  • Members
  • PipPip
  • Member
  • 15 posts

Posted 06 September 2006 - 04:56 PM

I have noticed that accessing MSSQL through ODBC is reasonably slow. It could just be a configuration issue through.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users