Wasn't that test done using JDBC though? MS SQL didn't have full version JDBC drivers or something like that - it's been a while since I read that.
Joshua Miller Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] -----Original Message----- From: Jonathan Sakai [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 2:05 PM To: CF-Talk Subject: Re: MS SQL vs MySQL WAS: [admin] List status I think I found it: http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp Jonathan Sakai Online Services Manager American College of Nurse-Midwives www.midwife.org www.midwifejobs.com >>> [EMAIL PROTECTED] 05/15/02 02:00PM >>> I've heard about that article, but haven't read it. Could you provide a link? It is well known that MySQL is very very fast reading, however under load it's record locking is not up to par with the big guys, and it's write speed is well below the rest. What MySQL can not touch is MS SQL's stored procedure and dts stuff. DTS alone is such a timesaver I wouldn't want to work without it again. Not to mention the ability to very easily integrate COM objects into TSQL, and tight XML support. Oh yeah and a wonderful client interface, Enterprise Manager, Query Analyzer, and SQL Profiler are hard to beat. jon ----- Original Message ----- From: "Tony Schreiber" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 1:25 PM Subject: MS SQL vs MySQL WAS: [admin] List status > What about the recent comparison in eWeek between MySQL, Oracl9i and > SQL2k? MySQL was neck and neck with Oracle in response time and > throughput, both better than SQL2k? > > > >I know that MySQL cannot really stand up to MS SQL but > > >when you are talking about the amount that MS SQL costs > > >versus using MySQL, I would us MySQL unless someone just > > >wanted to pay for MS SQL. > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
