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: