Re: Caching Queries and CACHEDAFTER

Sun, 21 May 2000 15:15:38 -0700 

Joseph -

I could do that, but it's not very feasible -  I can't just go tell my
client "well, for the sake of performance, stuff you add to the database
will only be available up to 24 hours after you enter it.  Also, any edits
or deletes you make won't be online up to 24 hours after you make the
changes." ....



----- Original Message -----
From: "Joseph Eugene" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 21, 2000 5:42 PM
Subject: Re: Caching Queries and CACHEDAFTER


> 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>&nbsp;</DIV>
> > <DIV><FONT face=3DArial size=3D2>I'm currently developing a site that =
> > I'd like to=20
> > use query caching on,&nbsp;and I have a few questions about how I should
=
> > go=20
> > about setting query caching up.</FONT></DIV>
> > <DIV>&nbsp;</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.&nbsp;
=
> > I'm=20
> > wondering though, if this is going to work at all - the Allaire docs say
=
> >
> > that&nbsp;I should specify a date value for cachedafter parameter - will
=
> >
> > cahcedafter work with a date time value?&nbsp; If it will, how should I
=
> > format=20
> > my date/time value?</FONT></DIV>
> > <DIV>&nbsp;</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>&nbsp;</DIV>
> > <DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
> > <DIV>&nbsp;</DIV>
> > <DIV><FONT face=3DArial size=3D2>Jay</FONT></DIV>
> > <DIV>&nbsp;</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.
>

------------------------------------------------------------------------------
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.

Reply via email to