why not use caching at both the db and cfmx level?
----- Original Message ----
From: Hugo Ahlenius <[EMAIL PROTECTED]>
To: [email protected]
Sent: Friday, February 16, 2007 2:56:01 AM
Subject: RE: [CFCDEV] where to do query caching...
Jeff,
That goes back a little bit to the spirit of my original question (if we
ignore the technical details).
You are saying that, by doing it in the database, you have integrated
the caching into the model (which your database is a part of) - which I
am a little bit reluctant to. By doing it that way, you don't avoid
round trips to the db server though (but they will be quick).
I am more keen on implementing caching closer to my framework and the
cfml application though - as I mentioned before...
/Hugo
--
Hugo Ahlenius
-------------------------------------------------------------
Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
Project Officer Phone: +46 8 412 1427
UNEP GRID-Arendal Fax: +46 8 723 0348
Stockholm Office Mobile: +46 733 467111
WWW: http://www.grida.no
Skype: callto:fraxxinus
-------------------------------------------------------------
| -----Original Message-----
| From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
| Of Jeff Smallwood
| Sent: Thursday, February 15, 2007 22:25
| To: [email protected]
| Subject: RE: [CFCDEV] where to do query caching...
|
| Only suggestion I have is don't overlook DB level caching if it is
| available in your environments. We're using MySQL and have seen
| excellent performance from its built-in query caching. And the great
| plus is that the dB level caching it smart enough to know when tables
| have been updated and therefore automatically clear the appropriate
| caches as needed. So you can be less concerned about what
| events should
| clear the cache or how long to keep it. You can off-load that logic to
| the db.
|
| May not be an option for you, but I wanted to mention it in case.
|
| -----Original Message-----
| From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
| Of Charlie
| Arehart
| Sent: Thursday, February 15, 2007 1:44 PM
| To: [email protected]
| Subject: RE: [CFCDEV] where to do query caching...
|
| Hugo may have shot himself in the foot mentioning BlueDragon there, as
| those
| who don't use it might have turned off immediately thinking they
| couldn't
| help. Note that (it seems to me) his question isn't about BD
| but rather
| more
| generically about where best to implement query caching in CFML when
| using
| frameworks.
|
| Just forget that he mentioned BD. :-) It simply adds some additional
| attributes to the existing CACHEDWITHIN and CACHEDAFTER of CFQUERY.
|
| I sense his question is whether to bother using those at all (even in
| CFMX)
| or to use something else, like caching the results in memory
| using other
| techniques, and doing it elsewhere in the chain of events
| that process a
| query within a framework.
|
| /Charlie
| http://www.carehart.org/blog/
|
| -----Original Message-----
| From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hugo
| Ahlenius
| Sent: Thursday, February 15, 2007 4:23 AM
| To: [email protected]
| Subject: [CFCDEV] where to do query caching...
|
| Hi,
|
| Any thoughts on where to implement query caching... ?
|
| I am using BlueDragon.Net, and it has some quite neat and
| fancy improved
| support for query caching, that I haven't implemented yet (I had
| actually
| forgotten about it, until it was brought up on the bluedragon-interest
| mailing list). Basically it lets you group and cache things in the
| cfquery
| cache, with some additional functionality compared to CFMX (at least
| compared to CFMX 6.1 - have no experience with CFMX7,
| yet)
|
| In working with Mach-II (my framework of choice), and I am kind of
| reluctant
| to implement too much of the caching directly into the model.
| Unless it is made as a part of the model with optional
| caching arguments
| to
| gateways and DAOs - getProducts(cache=true) or something.
|
| Currently I have my caching set up more closely to the application
| framework, and that works very well too (and is fully CFMX
| compatible),
| where some queries are cached in the listeners (the
| intermediate objects
| that acts as the interface between the framework and the model).
|
| Any comments?
|
| /Hugo
|
|
| --
| Hugo Ahlenius
|
| -------------------------------------------------------------
| Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
| Project Officer Phone: +46 8 412 1427
| UNEP GRID-Arendal Fax: +46 8 723 0348
| Stockholm Office Mobile: +46 733 467111
| WWW: http://www.grida.no
| Skype: callto:fraxxinus
| -------------------------------------------------------------
|
|
|
|
|
|
|
|
|
|
| You are subscribed to cfcdev. To unsubscribe, please follow the
| instructions
| at http://www.cfczone.org/listserv.cfm
|
| CFCDev is supported by:
| Katapult Media, Inc.
| We are cool code geeks looking for fun projects to rock!
| www.katapultmedia.com
|
| An archive of the CFCDev list is available at
| www.mail-archive.com/[email protected]
|
|
|
|
| You are subscribed to cfcdev. To unsubscribe, please follow the
| instructions at http://www.cfczone.org/listserv.cfm
|
| CFCDev is supported by:
| Katapult Media, Inc.
| We are cool code geeks looking for fun projects to rock!
| www.katapultmedia.com
|
| An archive of the CFCDev list is available at
| www.mail-archive.com/[email protected]
|
|
|
| You are subscribed to cfcdev. To unsubscribe, please follow
| the instructions at http://www.cfczone.org/listserv.cfm
|
| CFCDev is supported by:
| Katapult Media, Inc.
| We are cool code geeks looking for fun projects to rock!
| www.katapultmedia.com
|
| An archive of the CFCDev list is available at
| www.mail-archive.com/[email protected]
|
|
|
|
You are subscribed to cfcdev. To unsubscribe, please follow the instructions at
http://www.cfczone.org/listserv.cfm
CFCDev is supported by:
Katapult Media, Inc.
We are cool code geeks looking for fun projects to rock!
www.katapultmedia.com
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
You are subscribed to cfcdev. To unsubscribe, please follow the instructions at
http://www.cfczone.org/listserv.cfm
CFCDev is supported by:
Katapult Media, Inc.
We are cool code geeks looking for fun projects to rock!
www.katapultmedia.com
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
