[CDBI] An optimization question

Michael G Schwern schwern at pobox.com
Tue Sep 25 22:16:12 BST 2007

Tim Bunce wrote:
> On Tue, Sep 25, 2007 at 03:16:24PM -0400, Perrin Harkins wrote:
>> On 9/25/07, Eric W. Bates <ericx at vineyard.net> 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.

I'd suggest using a combination of dprof and DBI::Profile to get your total
performance numbers from a CDBI app.

Whip me, beat me, make my code compatible with VMS!

More information about the ClassDBI mailing list