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 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?
Odds are that you didn't tune MySQL at all. Unlike most commercial
database servers, MySQL "out of the box" isn't tuned for heavy usage.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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
