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
