PHP Developer's Network : Network Member Forums

Class: LSM Explain Plan


  Search   All class groups   Latest entries   Top 10 charts   Newsletter   Blog   Forums   Help FAQ  
  Login   Register  
Recommend this page to a friend! Trackback URL: http://www.phpclasses.org/trackback/browse/package/2264.html
      Classes of Claudio Adonai Muto  > 
LSM Explain Plan
  >  Download  >  Support forum Support forum  >  RSS 1.0 feed RSS 2.0 feed Latest changes  >  Stumble It! Stumble It!  >  Bookmark in del.icio.us Bookmark in del.icio.us  
  Screenshots Screenshots   Supplied by   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

  • Supplied by:

    • Picture of Claudio Adonai Muto
    Name: Claudio Adonai Muto <e-mail contact>
    Published packages: 6
    Country: Brazil Brazil - PHP jobs in Brazil
    Home page: http://www.cam.pro.br/
    Age: 34
    All time rank: 607
    Week rank: 982

    Browse this author's classes

  • 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
    Database management, accessing and searching
    		 View top rated classes
    Group folder image
    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%)
    1478
    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   Site map   Statistics   Site tips   Privacy policy   Contact  
For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2008 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products