Login   Register  
PHP Classes
elePHPant
Icontem

Class: LSM Explain Plan

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Claudio Adonai Muto  >  LSM Explain Plan  >  Download .tar.gz .zip  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: LSM Explain Plan
Support forum Support forum
Base name: lsmexplain_plan
Description: Show a MySQL query execution plan and performance
Related classes: , , , ,
Version: -
PHP version: 3
License: GNU General Public License (GPL)
All time users: 795 users
All time rank: 3476
Week users: 0 users
Week rank: 2503
Picture of Claudio Adonai Muto
Author: Claudio Adonai Muto <e-mail contact>
Packages: 6 Browse this author's classes Browse this author's classes
Country: Brazil Brazil - PHP jobs in Brazil
Age: 38
All time rank: 77055 in Brazil Brazil
Week rank: 1245 Down91 in Brazil Brazil Down
Innovation award
Innovation award
Nominee: 1x

Winner: 1x


  Detailed description  
This class can retrieve the explanation of the execution of a given MySQL database SELECT query and compute a relative performance factor.

The class executes an EXPLAIN query to retrieve the information about the tables, columns, indexes and search methods involved in a SELECT query.

It uses the retrieved information to compute a relative performance factor that is presented in a simple report along with other details pertaining to the execution plan of the query.

 

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Performance and optimization Tools to measure and optimize the performance of systems View top rated classes

  Screenshots Screenshots   Rate classes User ratings   Applications   Files Files  
  Files folder image Screenshots  
A screenshot that shows the result of a SQL statement
File Role Description
Accessible without login Image file sql.jpg Screen A screenshot that shows the result of a SQL statement


  Innovation Award  
PHP Programming Innovation award winner
April 2005
Winner
 When it is necessary to improve the performance of database applications, the developers often evaluate the SQL queries that are executed, so they can determine how to make the applications run faster.

MySQL has a SQL command named EXPLAIN that lets the developers see which tables, columns, indexes are involved in an SELECT query. Then they can consider eventual database changes that can make the query execute faster.

This class uses the information returned by the EXPLAIN command and computes a performance factor that can be used to easily determine if the changes in the query statement or in the database tables and indexes that are tried effectively lead to performance improvements.

Manuel Lemos

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Sufficient (66.7%)
Sufficient (66.7%)
-
-
-
-
Insufficient (40.0%)
1977
Month:
Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.
  Files folder image Files  
File Role Description
Plain text file LSMexplain_plan.class.php Class Executes a explain in a SQL statement

Download all files: lsmexplain_plan.tar.gz lsmexplain_plan.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.