[Catalyst] Caching SQL results for speed...?

Darren Duncan darren at darrenduncan.net
Wed Apr 13 06:19:15 GMT 2011


will trillich wrote:
> Okay, after some perl -D:NTYProf tester.pl <http://tester.pl> with 200 
> iterations:
> 70% of the time is taken up in five modules:
> 1) SQL::Abstract
> 2) DBIx::Class::ResultSet
> 3) Class::Accessor::Grouped
> 4) DBIx::Class::Storage::DBI
> 5) HTML::FormHandler::Field
> ...because in 200 iterations they were called millions of times each. 
> (The form requested has several select/option menus.)

So, several 5000s (millions / 200) of calls for a single screen?  That sounds 
like a lot for one screen.  Do you need that much? -- Darren Duncan



More information about the Catalyst mailing list