hmmm. I must not follow or misspoke or wasn't clear. The "data-layer" components I am caching are a series of CFC that call SPs. If tomorrow I switch from SQL server to postgres I'm going to have to rewrite all the CF code outside of those CFC's will remain the same -- I will have to re-tool the SP's and in same cases the code that directly calls them.
What I am caching, then, is not specific tables but the code that accesses my data. I am sorry I was not clear. Craig > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of cf_nut > Sent: Friday, July 25, 2003 9:33 AM > To: [EMAIL PROTECTED] > Subject: Re: [CFCDev] CFC Caching > > > --- "Craig Fisher" <[EMAIL PROTECTED]> wrote: > > I've done this and have no complaints thus far. The CFC's I > > cached were all > > data layer components as well. The only tip I that seems > > important enough > > to share is that you should code in a way that lets you ignore the > > cache or > > even rebuild it so things are more convenient during development. > > I did a > > this: [snip] > > Agree with the technique in principle, but I wouldn't implement it > in the data-layer, I'd do it one level above. > > To my mind the data-layer is purely about getting data in and out of > your data-store. If you change from Sql-server to postgres, or > Oracle to LDAP, you want to be rewriting data access logic, not > dealing with logically separate set of concepts (which wouldn't be > changing) such as "well, I know *this* table is going to be hit hard > so I'll cache it. " > > Andy > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
