On Fri, 2010-03-12 at 17:42 -0800, Ease Bus wrote: > Does mysql performance with mongrel and Snow Leopard differ from its > performance with Apache and Ubuntu? I am experiencing the issue of > slow performance in Ubuntu production environment compared to my > Leopard development environment. For the exact same code, after > pushing to Ubuntu server, the same action/view takes much longer to > complete and many more DB queries on the Ubuntu server: > > On my Leopard, I get: Completed in 643ms (DB: 322) | 302 Found > For Ubuntu, I get: Completed in 8803ms (DB: 517) | 302 Found > > The number after DB: is the number of SQL queries for that action I assume. > > Is there anything I should watch out for when pushing code from > Leopard to Ubuntu? > > Thanks much. ---- in the realm of expectations, I think traditionally, Macintosh OS X and FreeBSD in general have had some performance issues with MySQL and threading and I don't know that those issues have been resolved but my expectations are that generally, you should get much better performance out of Linux.
Of course there are so many factors that could easily influence the comparison including, RAM (sufficient? swapping?), MySQL indexes, SQL using sockets or TCP/IP, etc. Just for fun, I looked at my current project (in production mode) and the 'main' page is what I would consider a heavy load, several joined tables and calculations that require Geokit, distances from a specific point, many partials, a very large css, a ton of javascript, etc. and it says... Completed in 364ms (View: 200, DB: 117) (Fedora on Linode VPS with 384 RAM) so I gather you have some major issues going on. Craig -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
