PHP Classes
Icontem

Class: LSM Explain Plan


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Claudio Adonai Muto  >  LSM Explain Plan  >  Download  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: LSM Explain Plan Support forum
Base name: lsmexplain_plan
Description: Show a MySQL query execution plan and performance
Version: -
Required PHP version: 3
License: GNU General Public License (GPL)
All time users: 667 users
All time rank: 3042
Week users: 4 users
Week rank: 1919
 
  Screenshots Screenshots   Author   Group folder image Groups   Detailed description  
  Rate classes User ratings   Applications   Files Files  

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

Author

Picture of Claudio Adonai Muto
Name: Claudio Adonai Muto <e-mail contact>
Published packages: 6 Browse this author's classes Browse this author's classes
Country: Brazil Brazil - PHP jobs in Brazil
Home page: http://www.cam.pro.br/
Age: 35
All time rank: 671
Week rank: 716

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

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

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.

User ratings

Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Sufficient (66.7%)
Sufficient (66.7%)
-
-
-
-
Not sure (40.0%)
1644
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

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.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products