On Wed, Mar 17, 2010 at 7:43 PM, Jon Bennett <jmbenn...@gmail.com> wrote: > > Indexes make a huge difference, as does using the right column types. > Containable is great, but you still need to analyse what's being > retrieved and adjust. As little as possible generally! > >> Whilst there is the core cache library which is great, do you use any >> kind of component in front of this to abstract it? Or is it a case of >> manually checking whether the cached element exists in your controller >> action and then if not fetching from the DB? > > I have a custom solution based around Mile J's > http://www.milesj.me/blog/read/34/Cacheing-Each-Query-Individually. > It's pretty easy to cache stuff though, it's knowing when to clear > them out that's the tricky bit.
Cheers JB - great help as always! -- Alex Bovey Web Developer | Alex Bovey Consultancy Ltd Registered in England & Wales no. 6471391 | VAT no. 934 8959 65 a...@bovey.co.uk | t 0844 567 8995 | m 07828 649386 | f 0870 288 9533 PHP | MySQL | AJAX | XHTML | CSS | Javascript | XML | W3C Accessibility Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en To unsubscribe from this group, send email to cake-php+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.