# Windows-mysql performance

**URL:** <https://www.ruby-forum.com/t/windows-mysql-performance/135425>\
**Category:** Rails\
**Created:** [April 22, 2008, 2:38am UTC](https://www.ruby-forum.com/t/windows-mysql-performance/135425 "2008-04-22T02:38:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![boowebb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/e47774/32.png) [@boowebb](https://www.ruby-forum.com/u/boowebb)\
**Post date:** [April 22, 2008, 2:38am UTC](https://www.ruby-forum.com/t/windows-mysql-performance/135425/1 "2008-04-22T02:38:18Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![boowebb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/e47774/32.png) [@boowebb](https://www.ruby-forum.com/u/boowebb)\
**Post date:** [April 22, 2008, 2:43am UTC](https://www.ruby-forum.com/t/windows-mysql-performance/135425/2 "2008-04-22T02:43:35Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![boowebb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/e47774/32.png) [@boowebb](https://www.ruby-forum.com/u/boowebb)\
**Post date:** [April 22, 2008, 6:05am UTC](https://www.ruby-forum.com/t/windows-mysql-performance/135425/3 "2008-04-22T06:05:30Z")

</div>

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

On Mon, Apr 21, 2008 at 5:43 PM, Frederick C. \<  
removed\_email\_address@domain.invalid\> 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.  
removed\_email\_address@domain.invalid  
[http://boowebb.com/](http://boowebb.com/)