Hi all
I have a pb to cache a query or put it in an application variable(for a
query which rarely changes).
So what is the best choice?
Does CF Server treat the two in the same way or store them differently?
Below is a piece of my code...
Cached query...
<CFQUERY NAME="myquery" DATASOURCE="data"
cachedwithin="#createtimespan(365)#>
SELECT NAME,PARENT,PATH
FROM FAMILY
</CFQUERY>
Set query in application variable....
<CFQUERY NAME="application.myquery" DATASOURCE="data">
SELECT NAME,PARENT,PATH
FROM FAMILY
</CFQUERY>
Thanks all for your replies.
Josian Chung sin
CF- Developper
Ingecom Mauritius
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
