Tatva-Artha

meaning of "it"

Rails: Optimizing Database Indexes using query_analyzer and query_reviewer

without comments

When trying to identify various database query indexes (indices?) for optimizing databases, two plugins are useful.

Query Analyzer is very useful and has been around for a quite some time. It runs an EXPLAIN on each query sent to database and prints tabular output on console.

Query Reviewer is a new one that I used recently. It is very similar to Query Analyzer in functionality. However, it displays the result rendered on top of you existing page using absolutely positioned divs. It is well designed to be not very intrusive and can be enabled/disabled.

Both plugins require just installing them in vendor/plugins folders. That’s it.

Warning: Both these plugins work with mysql database only, since they depend on mysql’s EXPLAIN command.

http://www.tatvartha.com/wp-content/plugins/sociofluid/images/digg_16.png http://www.tatvartha.com/wp-content/plugins/sociofluid/images/reddit_16.png http://www.tatvartha.com/wp-content/plugins/sociofluid/images/stumbleupon_16.png http://www.tatvartha.com/wp-content/plugins/sociofluid/images/delicious_16.png http://www.tatvartha.com/wp-content/plugins/sociofluid/images/google_16.png http://www.tatvartha.com/wp-content/plugins/sociofluid/images/twitter_16.png

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Written by Sharad

September 18th, 2009 at 2:14 pm

Posted in All

Leave a Reply