Showing entries 1 to 1
Displaying posts with tag: suboptimal (reset)
May
30
2011
MySQL: Using Views as Performance Improvement Tools
Posted by Ovais Tariq on Mon 30 May 2011 19:16 UTC
Tags:

The most basic and most oft-repeated task that a DBA has to accomplish is to look at slow logs and filter out queries that are suboptimal, that consume lots of unnecessary resources and that hence slow down the database server. This post looks at why and how VIEWs can help against such suboptimal operations.

Showing entries 1 to 1