Re: [Dbix-class] Caching a resultset?

2013-01-21 Thread Peter Rabbitson
On Thu, Jan 17, 2013 at 01:06:43AM +1100, Peter Rabbitson wrote: On Wed, Jan 16, 2013 at 02:47:19PM +0100, Alexander Hartmaier wrote: I had NO idea that's already possible, thanks for the great pointers! Do we want to include that in the Cookbook? There is no such thing as too much

Re: [Dbix-class] Caching a resultset?

2013-01-16 Thread Alexander Hartmaier
On 2013-01-15 21:49, Peter Rabbitson wrote: On Tue, Jan 15, 2013 at 05:12:12PM +0100, Alexander Hartmaier wrote: On 2013-01-15 16:51, Peter Rabbitson wrote: 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

Re: [Dbix-class] Caching a resultset?

2013-01-16 Thread Peter Rabbitson
On Wed, Jan 16, 2013 at 11:03:43AM +0100, Alexander Hartmaier wrote: On 2013-01-15 21:49, Peter Rabbitson wrote: On Tue, Jan 15, 2013 at 05:12:12PM +0100, Alexander Hartmaier wrote: On 2013-01-15 16:51, Peter Rabbitson wrote: On Tue, Jan 15, 2013 at 10:09:19AM -0500, Jesse Sheidlower wrote:

Re: [Dbix-class] Caching a resultset?

2013-01-16 Thread Peter Rabbitson
On Wed, Jan 16, 2013 at 02:51:59AM +1100, Peter Rabbitson wrote: 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

Re: [Dbix-class] Caching a resultset?

2013-01-16 Thread Alexander Hartmaier
On 2013-01-16 13:20, Peter Rabbitson wrote: On Wed, Jan 16, 2013 at 11:03:43AM +0100, Alexander Hartmaier wrote: On 2013-01-15 21:49, Peter Rabbitson wrote: On Tue, Jan 15, 2013 at 05:12:12PM +0100, Alexander Hartmaier wrote: On 2013-01-15 16:51, Peter Rabbitson wrote: On Tue, Jan 15, 2013 at

Re: [Dbix-class] Caching a resultset?

2013-01-16 Thread Peter Rabbitson
On Wed, Jan 16, 2013 at 02:47:19PM +0100, Alexander Hartmaier wrote: I had NO idea that's already possible, thanks for the great pointers! Do we want to include that in the Cookbook? There is no such thing as too much documentation. Please go for it. Also see if you can do something about [1]

Re: [Dbix-class] Caching a resultset?

2013-01-15 Thread Jesse Sheidlower
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 =

Re: [Dbix-class] Caching a resultset?

2013-01-15 Thread Jesse Sheidlower
On Tue, Jan 15, 2013 at 02:15:02PM +, David Cantrell wrote: On Sun, Jan 13, 2013 at 11:35:06PM -0500, Jesse Sheidlower wrote: I have a Catalyst app that very frequently (pretty much every request) requires several DBIC resultsets that return a small number of values, that very rarely

Re: [Dbix-class] Caching a resultset?

2013-01-15 Thread Peter Rabbitson
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?

Re: [Dbix-class] Caching a resultset?

2013-01-15 Thread Peter Rabbitson
On Tue, Jan 15, 2013 at 05:12:12PM +0100, Alexander Hartmaier wrote: On 2013-01-15 16:51, Peter Rabbitson wrote: 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

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Peter Rabbitson
On Sun, Jan 13, 2013 at 11:35:06PM -0500, Jesse Sheidlower wrote: I have a Catalyst app that very frequently (pretty much every request) requires several DBIC resultsets that return a small number of values, that very rarely change. I'm trying to cache this, so I can update the cache when

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Peter Rabbitson
On Mon, Jan 14, 2013 at 09:26:04AM +0100, Alexander Hartmaier wrote: The resultset has a ref to the schema which in turn has one to its database connection which can't be serialized/cached. After unfreezing it you have to link the $rs back to a schema with a working database connection. I

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Jesse Sheidlower
On Mon, Jan 14, 2013 at 10:13:44PM +1100, Peter Rabbitson wrote: On Sun, Jan 13, 2013 at 11:35:06PM -0500, Jesse Sheidlower wrote: I have a Catalyst app that very frequently (pretty much every request) requires several DBIC resultsets that return a small number of values, that very

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Peter Rabbitson
On Mon, Jan 14, 2013 at 06:30:42AM -0500, Jesse Sheidlower wrote: On Mon, Jan 14, 2013 at 10:13:44PM +1100, Peter Rabbitson wrote: On Sun, Jan 13, 2013 at 11:35:06PM -0500, Jesse Sheidlower wrote: I have a Catalyst app that very frequently (pretty much every request) requires several

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Jesse Sheidlower
On Mon, Jan 14, 2013 at 11:06:56PM +1100, Peter Rabbitson wrote: On Mon, Jan 14, 2013 at 06:30:42AM -0500, Jesse Sheidlower wrote: On Mon, Jan 14, 2013 at 10:13:44PM +1100, Peter Rabbitson wrote: On Sun, Jan 13, 2013 at 11:35:06PM -0500, Jesse Sheidlower wrote: I have a Catalyst app

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Peter Rabbitson
On Sun, Jan 13, 2013 at 11:35:06PM -0500, Jesse Sheidlower wrote: I have a Catalyst app that very frequently (pretty much every request) requires several DBIC resultsets that return a small number of values, that very rarely change. I'm trying to cache this, so I can update the cache when

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread will trillich
One problem I see with the exact code posted here is a typo referring to singular-vs-plural on the hash key: On Sun, Jan 13, 2013 at 10:35 PM, Jesse Sheidlower jes...@panix.com wrote: unless ( $c-stash-{subjects} = $cache-get( 'subjects' ) ) { $c-stash-{subjects} =

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Jesse Sheidlower
On Mon, Jan 14, 2013 at 09:41:45AM -0600, will trillich wrote: One problem I see with the exact code posted here is a typo referring to singular-vs-plural on the hash key: On Sun, Jan 13, 2013 at 10:35 PM, Jesse Sheidlower jes...@panix.com wrote: unless ( $c-stash-{subjects} =

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Jesse Sheidlower
On Tue, Jan 15, 2013 at 01:30:55AM +1100, Peter Rabbitson wrote: On Sun, Jan 13, 2013 at 11:35:06PM -0500, Jesse Sheidlower wrote: I have a Catalyst app that very frequently (pretty much every request) requires several DBIC resultsets that return a small number of values, that very

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Peter Rabbitson
On Mon, Jan 14, 2013 at 11:07:34AM -0500, Jesse Sheidlower wrote: On Tue, Jan 15, 2013 at 01:30:55AM +1100, Peter Rabbitson wrote: On Sun, Jan 13, 2013 at 11:35:06PM -0500, Jesse Sheidlower wrote: I have a Catalyst app that very frequently (pretty much every request) requires several

[Dbix-class] Caching a resultset?

2013-01-13 Thread Jesse Sheidlower
I have a Catalyst app that very frequently (pretty much every request) requires several DBIC resultsets that return a small number of values, that very rarely change. I'm trying to cache this, so I can update the cache when the values change and not have to hit my DB a half-dozen times on every

Re: [Dbix-class] Caching a resultset?

2013-01-13 Thread Hailin Hu
If you are using MySQL, I think query cache of MySQL works for you. Hitting query cache is supposed fast enough for general purpose. Is it really necessary to try to cache a RS, which is not a easy job, I'm afraid. On Mon, Jan 14, 2013 at 1:35 PM, Jesse Sheidlower jes...@panix.com wrote: I have