Re: Feature request prop for django db cache extention

2011-10-16 Thread Russell Keith-Magee
On Sun, Oct 16, 2011 at 12:45 PM, Alexander Schepanovski wrote: > As one of the authors of multiple third-party packages I can say that > though it is not too hard still integrating cache into ORM have some > problems. There are several approaches: > > 1. Custom Manager and QuerySet subclasses (ca

Re: Feature request prop for django db cache extention

2011-10-15 Thread Alexander Schepanovski
As one of the authors of multiple third-party packages I can say that though it is not too hard still integrating cache into ORM have some problems. There are several approaches: 1. Custom Manager and QuerySet subclasses (cachebot, cache-machine). The clearest one and lest powerful - can't use wit

Re: Feature request prop for django db cache extention

2011-10-15 Thread Russell Keith-Magee
On Sun, Oct 16, 2011 at 8:26 AM, Alex Gaynor wrote: > > > On Sat, Oct 15, 2011 at 8:23 PM, Russell Keith-Magee > wrote: >> >> On Sunday, October 16, 2011, Cal Leeming [Simplicity Media Ltd] >> wrote: >> > Hi Russell, >> > Thanks for the detailed response. It looks like both those solutions you >

Re: Feature request prop for django db cache extention

2011-10-15 Thread Alex Gaynor
On Sat, Oct 15, 2011 at 8:23 PM, Russell Keith-Magee < russ...@keith-magee.com> wrote: > On Sunday, October 16, 2011, Cal Leeming [Simplicity Media Ltd] < > cal.leem...@simplicitymedialtd.co.uk> wrote: > > Hi Russell, > > Thanks for the detailed response. It looks like both those solutions you > p

Re: Feature request prop for django db cache extention

2011-10-15 Thread Russell Keith-Magee
On Sunday, October 16, 2011, Cal Leeming [Simplicity Media Ltd] < cal.leem...@simplicitymedialtd.co.uk> wrote: > Hi Russell, > Thanks for the detailed response. It looks like both those solutions you pasted have already dealt with this functionality - so thank you for bringing these up. > Although

Re: Feature request prop for django db cache extention

2011-10-15 Thread Cal Leeming [Simplicity Media Ltd]
Hi Russell, Thanks for the detailed response. It looks like both those solutions you pasted have already dealt with this functionality - so thank you for bringing these up. Although it'd be really nice to see this in the core one day, is it worth me pursuing to try and have something like this lo

Re: Feature request prop for django db cache extention

2011-10-14 Thread Russell Keith-Magee
On Saturday, October 15, 2011, Cal Leeming [Simplicity Media Ltd] < cal.leem...@simplicitymedialtd.co.uk> wrote: > Hey all, > Today, we had a client getting around 600k webapp requests per hour (avg 6k/min), and had to do some emergency perf hotfixes (CodeIgniter+PHP) > In the end, we monkey-patche

Re: Feature request prop for django db cache extention

2011-10-14 Thread Javier Guerra Giraldez
On Fri, Oct 14, 2011 at 9:13 PM, Cal Leeming [Simplicity Media Ltd] wrote: > In the end, we monkey-patched the code so raw SQL statement was used to > generate a cache key, and we performed a lookup on that. why SQL? it seems a memcached INCR would be faster and easier to distribute (if you have

Feature request prop for django db cache extention

2011-10-14 Thread Cal Leeming [Simplicity Media Ltd]
Hey all, Today, we had a client getting around 600k webapp requests per hour (avg 6k/min), and had to do some emergency perf hotfixes (CodeIgniter+PHP) In the end, we monkey-patched the code so raw SQL statement was used to generate a cache key, and we performed a lookup on that. It was absolutel