Re: [CDBI] An optimization question

Tim Bunce <[email protected]> Tue, 25 Sep 2007 20:51:55 +0100
Newsgroups gmane.comp.lang.perl.modules.class-dbi
Message-ID <[email protected]>
On Tue, Sep 25, 2007 at 03:16:24PM -0400, Perrin Harkins wrote:
> On 9/25/07, Eric W. Bates <[email protected]> wrote:
> > e.g. somehow 900,000 calls to name_lc seems excessive when the core
> > program is handling something on the order of 850 records.
> 
> If you sort by wall time with the -r switch, this will most likely
> drop off the radar.  Database calls take a lot of wall time and very
> little CPU time so the default sort from DProf gives very strange
> results in database apps.

The granularity of the cpu and system time 'ticks' is just too course to
get meaningful numbers for most apps, database or otherwise.

Tim.