MySQL vs MS-SQL performance

2001-03-27 Thread Steve Quezadas
Hey guys, Most of the accounts I have read about MySQL was that it was one of the fastest databases around. Now, for development purposes I created a FreeBSD system with JUST MySQL (no other major processes). Then I created a separate Windows 2000 ASP server to server as our development

Re: MySQL vs MS-SQL performance

2001-03-27 Thread Jeremy D . Zawodny
On Tue, Mar 27, 2001 at 02:12:36PM -0800, Steve Quezadas wrote: Anyways, a period of time elapsed and we decided to move to MS-SQL server for feature reasons, and when we had the MS-SQL ODBC driver point to the newly created MS-SQL server (roughly same specs), it was like 50% faster! What

RE: MySQL vs MS-SQL performance

2001-03-27 Thread Oson, Chris M.
: Tuesday, March 27, 2001 4:18 PM To: [EMAIL PROTECTED]; Steve Quezadas Subject: Re: MySQL vs MS-SQL performance Steve, I also experienced the same results you did until I realized that the MS-SQL connection was using pooled connections and my use of MySQL wasn't. After I started using persistent