There's a chapter in the Practical mod_perl book by Stas Bekman which has an overview of profiling and includes a section on Apache::DProf , this might be able to help you out.

From other posts on this thread though it might just be worth it to go with Cache::Memcached, which should provide a big speedup.