windows-mysql performance

In working with Windows v. Mac I've noticed about a 5x difference
working with MySQL in favor of Macintosh. This is a problem for some
of our developers that are on the Windows platform.

In running tests against the db on both platforms it does not seem
that MySQL is the culprit - performance is comparable against a range
of queries.

However, running these same queries through ruby/rails shows this
performance difference.

We're runing MySQL 5.0, ruby 1.8.6, rails 2.0.2, mysql 2.7.3.

Has anyone else seen these performance issues and corrected them with
the mysql-windows gem?

Jeff

In working with Windows v. Mac I've noticed about a 5x difference
working with MySQL in favor of Macintosh. This is a problem for some
of our developers that are on the Windows platform.

In running tests against the db on both platforms it does not seem
that MySQL is the culprit - performance is comparable against a range
of queries.

However, running these same queries through ruby/rails shows this
performance difference.

Well ruby itself is well known to be slower on windows (as compared to
the more unix like platforms). Not sure why.

Fred

“slower” is one thing - 500% slower is something else entirely :slight_smile: