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.