profiling DBI (was Re: apache children waits for each other?)

[Malcolm J Harwood <mj...@liminalflux.net>]

> >You can look at the tuning information on http://modperlbook.org/ for
> >some advice as well.  And don't forget that there is a profiler for DBI
> >queries that comes with DBI.

Somehow I managed to miss the existence of DBI::Profile. Has anyone gotten 
this working with Apache::DBI (so that it aggregates across the entire 
lifetime of the DB connection)?



-- 
"You heard Mr. Garibaldi. You did the right thing."
"Darling, I did the necessary thing. That is not always the same as
 the right thing."
- Janice and Laura Rosen in Babylon 5:"The Quality of Mercy"

Re: profiling DBI (was Re: apache children waits for each other?)

["Philip M. Gollucci" <pg...@p6m7g8.com>]

Perrin Harkins wrote:
> Malcolm J Harwood wrote:
> 
>> Somehow I managed to miss the existence of DBI::Profile. Has anyone 
>> gotten this working with Apache::DBI (so that it aggregates across the 
>> entire lifetime of the DB connection)?
> 
> 
> Just use DBI::ProfileDumper::Apache.
I don't believe thats been ported mp2.
Also doesn't look that hard to do so.

-- 
END
------------------------------------------------------------
     What doesn't kill us can only make us stronger.
                 Nothing is impossible.
				
Philip M. Gollucci (pgollucci@p6m7g8.com) 301.254.5198
Consultant / http://p6m7g8.net/Resume/
Senior Developer / Liquidity Services, Inc.
   http://www.liquidityservicesinc.com
        http://www.liquidation.com
        http://www.uksurplus.com
        http://www.govliquidation.com
        http://www.gowholesale.com

Re: profiling DBI (was Re: apache children waits for each other?)

[Perrin Harkins <pe...@elem.com>]

Malcolm J Harwood wrote:
> Somehow I managed to miss the existence of DBI::Profile. Has anyone gotten 
> this working with Apache::DBI (so that it aggregates across the entire 
> lifetime of the DB connection)?

Just use DBI::ProfileDumper::Apache.

- Perrin