How to optimize sql and rails code, software?

Hi,

I am currently building a rails application and am looking for some
software to monitor mySQL queries and time it takes to load a page.

has anyone got any suggestions?

cheers,
scott

scott wrote:

Hi,

I am currently building a rails application and am looking for some
software to monitor mySQL queries and time it takes to load a page.

has anyone got any suggestions?

cheers,
scott
You log files are a good start - http://rails-analyzer.rubyforge.org/
will show you what the actions taking the most time are.
railsbench (http://railsbench.rubyforge.org/) is pretty handy for
measuring the time it takes to process a certain request.
You can also ask mysql to log slow queries for you.
Once you’ve got there profile to find the culprit

Fred