[Dbix-class] Caching a resultset?
rabbit+dbic at rabbit.us
Tue Jan 15 15:51:59 GMT 2013
On Tue, Jan 15, 2013 at 10:09:19AM -0500, Jesse Sheidlower wrote:
> On Tue, Jan 15, 2013 at 05:18:06AM +1100, Peter Rabbitson wrote:
> > On Mon, Jan 14, 2013 at 11:07:34AM -0500, Jesse Sheidlower wrote:
> > > >
> > > > So apart from the mystery around the nonsensical exception - does this help?
> > > >
> > > > local $DBIx::Class::ResultSourceHandle::thaw_schema = $c->model(...)->schema;
> > >
> > > Yes! Putting that before the "unless" seems to make everything work
> > > correctly.... Will be testing further this afternoon. Thanks!
> > Please let me know if wider testing is succesful.
> In one sense, wider testing was indeed successful. The RS was cached
> properly, it worked in several different environments, etc.
> However, it didn't "work" in one particularly crucial way, which in
> retrospect I'm surprised I didn't think about: the resultset may have
> been cached, but once I get it back, it's still just a resultset, so
> when I use it again in the template, it hits the database again. Every
> This is exactly what I wanted to avoid by this whole escapade.
You need to combine the above with  and/or .
More information about the DBIx-Class