Hi.
Well, there are too few information to say something concrete. Maybe,
for your enviromnet, MS-SQL is really faster, maybe MySQL wasn't well
tuned.
Anyhow, I wanted to point out, that there are two MySQL ODBC drivers
around, one with debugging enabled, the other one without debugging.
The one with debugging is a magnitude slower than the other and this
may already explain the difference you noticed.
Btw, ODBC isn't really a fast access method, anyhow (and assume that
MS has optimized out their own software).
Any other pointers?
Bye,
Benjamin.
On Tue, Mar 27, 2001 at 02:12:36PM -0800, [EMAIL PROTECTED] wrote:
> 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 server for our new site. The two servers
> communicated via ODBC.
>
> 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 gives? Is MySQL *really* that slow, MS-SQL
> *really* that fast, or maybe there was some weird setting in the
> ODBC driver or the MySQL server that I didn't switch right which
> made it go slow. I am not sure.
>
> Or maybe Microsoft, in their monopolistic ways, created special
> hooks between ASP and MS-SQL server to make the communication go
> somehow faster. Anyone had similar experiences to mine?
> - Steve
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
