Why wouldnt you use Cachewithin=#CreateTimeSpan(Days, hours, minutes,
seconds)#
if you are caching the data which will not be pretty much changed
(this is if you know how often the data changes)
and if you set it for a day or , the query only runs once that day
and you should see any performance hits..
----- Original Message -----
From: "Jay Sudowski - Handy Networks LLC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 21, 2000 4:00 PM
Subject: Caching Queries and CACHEDAFTER
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_04FE_01BFC33D.B4E4AD10
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hey all -
>
> I'm currently developing a site that I'd like to use query caching on, =
> and I have a few questions about how I should go about setting query =
> caching up.
>
> Because the site will only be periodically updated, I figured that I =
> would store the date/time a table is modified as an application variable =
> and then just use that variable as the cachedafter value. I'm wondering =
> though, if this is going to work at all - the Allaire docs say that I =
> should specify a date value for cachedafter parameter - will cahcedafter =
> work with a date time value? If it will, how should I format my =
> date/time value?
>
> Generally speaking, is using cachedafter and storing the date/time a =
> specific table was modified in an application variable a good way to go =
> about caching queries?
>
> Thanks,
>
> Jay
>
>
> ------=_NextPart_000_04FE_01BFC33D.B4E4AD10
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Diso-8859-1" =
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>Hey all -</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>I'm currently developing a site that =
> I'd like to=20
> use query caching on, and I have a few questions about how I should =
> go=20
> about setting query caching up.</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Because the site will only be =
> periodically updated,=20
> I figured that I would store the date/time a table is modified as an =
> application=20
> variable and then just use that variable as the cachedafter value. =
> I'm=20
> wondering though, if this is going to work at all - the Allaire docs say =
>
> that I should specify a date value for cachedafter parameter - will =
>
> cahcedafter work with a date time value? If it will, how should I =
> format=20
> my date/time value?</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Generally speaking, is using =
> cachedafter and=20
> storing the date/time a specific table was modified in an application =
> variable a=20
> good way to go about caching queries?</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Jay</FONT></DIV>
> <DIV> </DIV></BODY></HTML>
>
> ------=_NextPart_000_04FE_01BFC33D.B4E4AD10--
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
