I saw "data-layer" and "cache" in the same sentence and concluded (wrongfully it seems) you were caching 'stateful' cfcs, implying caching of query results. That looked like a contrast to our approach which was to put into our datalayer only code that was specific to our current data-store (so therefore code related to caching query results would be elsewhere).
It looks like you're caching just the code itself. We haven't got to the point where we need to do that yet. Andy. --- "Craig Fisher" <[EMAIL PROTECTED]> wrote: > 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). ---------------------------------------------------------- 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).
