LSM Explain Plan
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| Author | ||
 |
|
Innovation award Nominee: 1x Winner: 1x | |||||||||||||||||||
Browse all classes by 
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.
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.
| Classes of Claudio Adonai Muto | > | LSM Explain Plan | > | Download .zip .tar.gz | > |  Support forum |
> |  Blog |
> |   Latest changes |
||
|
|||||||||||||||||||||||
| Groups |  Screenshots |
 User ratings |
Applications |  Files |
||||||
| Groups | ||
 |
Databases | Database management, accessing and searching | View top rated classes |
|
Performance and optimization | Tools to measure and optimize the performance of systems | View top rated classes |
| Screenshots |
||
 |
|
| Innovation Award | ||
 April 2005 Winner Prize: One copy of the Zend Studio |
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 | ||||||||
|---|---|---|---|---|---|---|---|---|
| All time: | ||||||||
| Month: | ||||||||
| Applications that use this class | ||
No application links were specified for this class.
If you know an application of this package, send a message to the author to add a link here.| Download all files: lsmexplain_plan.tar.gz lsmexplain_plan.zip |
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2013