James,
try this out.
<cfquery name="qryName" datasource="yourDatasource"
cachedwithin="#CreateTimeSpan(0,0,10,0)#">
the most important is CreateTimespan this caches your results for 10
minutes. #CreateTimeSpan(days, hours, minutes, seconds)#
cheers and good luck,
nelson
----Original Message Follows----
From: James Taavon <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Caching a Query: How To?
Date: Fri, 12 Jan 2001 11:00:07 -0500
Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id
MHotMailBC287BC70067D820F3B7CF1F7A8C43110; Fri Jan 12 08:29:01 2001
Received: from houseoffusion.com ([207.31.122.140]) by
www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID#
0-54969U100L100S0V35) with ESMTP id com for
<[EMAIL PROTECTED]>; Fri, 12 Jan 2001 11:10:27 -0500
>From [EMAIL PROTECTED] Fri Jan 12 08:30:56 2001
Message-id: <[EMAIL PROTECTED]>
I have three different queries on page that the only difference among
them is what the results are ordered by. I suppose that I can cache the
query the so when the user selects how they want the list sorted, the
process time will be decreased. My question is I need help because I
have never done it before. Any guidance would be appreciated.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
