Zend_Db_Profiler not logging db connection time?

Answer 1

Hi,

The profiler 'bundles' connection and other operations in with the general queries.

There's three ways you might examine the connection specifically:

1. Set a filter on the profiler during setup:

   $profiler->setFilterQueryType(**Zend_Db_Profiler::CONNECT**);
   

   Then the resultant profiles will only include 'connect' operations.

2. Specify a query type when you retrieve the Query Profiles:

   $profiles = $profiler->getQueryProfiles(**Zend_Db_Profiler::CONNECT**);
   

3. Examine the query objects directly during the iteration:

   foreach($profiler->getQueryProfiles() as $query) {
   if ($query->getQueryType() == Zend_Db_Profiler::CONNECT &&
      $query->getElapsedSecs() > $longestConnectionTime) {
          $longestConnectionTime  = $query->getElapsedSecs();
      } 
   }
   

You'll not find great detail in there, it's logged just as a 'connect' operation along with the time taken.