On Feb 16, 8:48 am, Mike Judge <[email protected]> wrote: > ActiveRecord does nice benchmarks in the logs, helping you identify > slow queries as they happen: > > ArtistEntity Load (0.5ms) SELECT * FROM `data`.`artists` WHERE > (`data`.`artists`.`arid` = 'qau') > > Any idea how to enable some sort of inline benchmarks in Sequel query > logs? > > SELECT * FROM `data`.`artists` WHERE (`data`.`artists`.`arid` = > 'qau')
not a direct answer to your question, but for this I use PQA (http:// pqa.projects.postgresql.org/). it's originally a postgres-specific tool but they support MySQL as well. it's not integrated with your application logging (works on database logfiles instead) but has some nice features like query normalisation and aggregation to find queries that aren't individually slow but that are executed many times and would benefit from optimisation. an example report based on RubyForge's database activity - http://pqa.projects.postgresql.org/example.html cheers Russell -- You received this message because you are subscribed to the Google Groups "sequel-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/sequel-talk?hl=en.
