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 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 22 Apr 2008, at 01:37, boowebb wrote:> > 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> 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 > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
"slower" is one thing - 500% slower is something else entirely :-) On Mon, Apr 21, 2008 at 5:43 PM, Frederick Cheung < frederick.cheung-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > > On 22 Apr 2008, at 01:37, boowebb wrote: > > > > > 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 > > 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 > > > > > > > > > >-- Jeff Webb jeff-OBTZZsKxNvRBDgjK7y7TUQ@public.gmane.org http://boowebb.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---