Hi
At 14:12 27/03/2001 -0800, Steve Quezadas 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.
ODBC is the bottleneck. Try using the mysql native tools i.e. mysql client
application, mysqladmin, etc then you will notice a difference. The ODBC
drive has to do a lot of translation work so with MS-SQL the translation
work is minimal because it is Microsoft's baby. That's is why MySQL is slow
by comparison.
>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
Regards
John
MySQL Development Team
__ ___ ____ __ __
/ |/ /_ __/ __/ __ \/ / John Dean <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\____/ Mansfield, England, UK
<___/
---------------------------------------------------------------------
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
