[Catalyst] Caching SQL results for speed...?
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
> 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