|Classes of Claudio Adonai Muto||>||LSM Explain Plan||>||Download .zip .tar.gz||>||Support forum||>||Blog||>||Latest changes|
|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|
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.
|Applications that use this class|
|LSMexplain_plan.class.php||Class||Executes a explain in a SQL statement|