coldfusion 8 can cache bound (cfqueryparam'ed) queries, that might be enough to avoid even considering not even using any other caching layer in your application
plus you can use a combination of application and session scope caches as well z On Tue, Nov 18, 2008 at 10:18 PM, Tom Chiverton <[EMAIL PROTECTED]> wrote: > > On Tuesday 18 Nov 2008, Dawson, Michael wrote: >> I'm toying with the idea of using store procs on a project. This project >> requires about 10 queries to build a single page. > > That's nothing, trust me :-) > >> So, even though I can return multiple recordsets, with a stored proc, am I >> breaking any of the concepts or best-practices of OOP? > > Your 10 (or whatever) different CFCs might well share a common query cache (or > caching system). > This isn't a problem, if they all get injected with the same CFC for managing > that - in ColdSpring, for instance, you'd create a 'query cache' singleton > for them all to use. > > -- > Tom Chiverton > > > > **************************************************** > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in England and > Wales under registered number OC307980 whose registered office address is at > Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list > of members is available for inspection at the registered office. Any > reference to a partner in relation to Halliwells LLP means a member of > Halliwells LLP. Regulated by The Solicitors Regulation Authority. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above and may > be confidential or legally privileged. If you are not the addressee you must > not read it and must not use any information contained in nor copy it nor > inform any person other than Halliwells LLP or the addressee of its existence > or contents. If you have received this email in error please delete it and > notify Halliwells LLP IT Department on 0870 365 2500. > > For more information about Halliwells LLP visit www.halliwells.com. > > > > -- Zac Spitzer - http://zacster.blogspot.com http://ennoble.dreamhosters.com/mapguide-central/ +61 405 847 168 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CFCDev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfcdev?hl=en -~----------~----~----~----~------~----~------~--~---
