Quoting Ease Bus <[email protected]>: > 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. >
Do you have the same amounts of data in the DB in production and development environments? The number after 'DB:' is the number of milliseconds the DB access required. The difference in DB access times are not nearly as big as the the controller and rendering times (Completed time minus DB time). I'm guessing production has more data in the DB and more data found and rendered, hence increased run times. But the development laptop may be a lot faster than the server (higher clock speeds, faster rotating disks, faster disk busses, e.g., SATA and USB 2.0 can be much faster than PATA). You might try disk and other benchmarks on both machines. HTH, Jeffrey -- 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.
