Windows-mysql performance

Rails
1

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

2

On 22 Apr 2008, at 01:37, boowebb wrote:

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

3

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

On Mon, Apr 21, 2008 at 5:43 PM, Frederick C. <
[email protected]> wrote:

that MySQL is the culprit - performance is comparable against a range
We’re runing MySQL 5.0, ruby 1.8.6, rails 2.0.2, mysql 2.7.3.

–

Jeff W.
[email protected]
http://boowebb.com/