Database Operations Analysis using zend_profiler

The Zend Framework offers its own logging solution for all SQL queries to profile what is run, and how long it takes to execute, using Zend_Db_Profiler. The profiler can be enabled by passing an option called "profiler" with a boolean TRUE value with the options when constructing a database adapter. Thereafter you can instantiate the Zend_Db_Profiler class and use a variety of methods to examine how many queries were profiled, how long they took in total to execute, and retrieve an array of query profiles on which to perform a more in-depth analysis using the accompanying filters. There's even a special Zend_Db_Profiler_Firebug class so you can view profiling data on the fly through the Firebug console in Firefox.

Usage
in Bootstrap file

// turn on profiler:
 $db->getProfiler()->setEnabled(true);

in Action before all queries

$profiler = $db->getProfiler();

Bottom of the function

foreach ($profiler->getQueryProfiles() as $query) {
           
          echo '
'.$query->getQuery();
          echo ' TIME: ' .$query->getElapsedSecs()." Seconds";
   
      }

It will list the Connection Time and all other executed queries with taken time

Zend Framework v1.7.4 is released

The latest update to Zend Framework was just released today and is available for download:

http://framework.zend.com/download/latest/

31 separate issues were fixed in this release. A full list of all issues addressed may be found here:

http://framework.zend.com/issues/secure/IssueNavigator.jspa?requestId=10944