Re: I need some good old advice.

>Jim, > >How do I know where in the array the record is sitting i.e. [4]? The "4" in this case is the row of the query you want to change. The format is "QueryName[ColumnName][RowNumber]" or "QueryName.ColumnName[RowNumber]" So what you really need to know is the row number of the record in qu

Re: I need some good old advice.

ant that processes be built around a site >like this to ensure changes in how the data structure is handled occur for >every action that affects the structure. Of course, this is why we use >Visio. > >This overly-long message started off with a discussion about caching in >general.

RE: I need some good old advice.

te that up as well. M -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:35 PM To: CF-Talk Subject: Re: I need some good old advice. Jon, Your comment has the meat I'm looking for! Thanks. What exactly do you mean by: "schedule the cache u

Re: I need some good old advice.

application scope) you could run updates on the cached >>query at the same time that you run them on the DB. >> >>I'd have to check to see if it would work, but I don't see why not. >> >> >>-- Ben Doom >> Programmer & General Lackey >>

RE: I need some good old advice.

gt;-- Ben Doom >Programmer & General Lackey >Moonbow Software, Inc > >: -Original Message- >: From: James Blaha [mailto:[EMAIL PROTECTED] >: Sent: Tuesday, July 15, 2003 12:04 PM >: To: CF-Talk >: Subject: Re: I need some good old advice. >: >: >: Jim, &

Re: I need some good old advice.

Tuesday, July 15, 2003, 1:35:16 PM, you wrote: JB> Jon, JB> Your comment has the meat I’m looking for! Thanks. JB> What exactly do you mean by: JB> “schedule the cache update, and build in logic on each page request to JB> test if the cache exists, if not, requery immediately” We use cfschedul

RE: Re: I need some good old advice.

James you can find it here: -(watch for the wrapping of the url) http://www.macromedia.com/cfusion/exchange/index.cfm;jsessionid=48303189051048863726495?view=sn131&extID=1002264 It is a great tag, it was developed to help with the complex caching strategies needed for Spectra. Good luck. Kind

Re: I need some good old advice.

Mike, cf_supercache sounds interesting. Where can I get my hands on it and the documentation? Regards, JB Mike Brunt wrote: >This may or may not be relevant but we have been involved in some very creative use >of a custom tag called cf_supercache. You do some really granular controlled co

Re: I need some good old advice.

Jon, Your comment has the meat I’m looking for! Thanks. What exactly do you mean by: “schedule the cache update, and build in logic on each page request to test if the cache exists, if not, requery immediately” Can you please give me some kind of an example of what the templates involved woul

RE: Re: I need some good old advice.

> >>I'd have to check to see if it would work, but I don't see why not. >> >> >>-- Ben Doom >>Programmer & General Lackey >>Moonbow Software, Inc >> >>: -Original Message- >>: From: James Blaha [mailto:[EMAIL PROTECTED] >>

Re: I need some good old advice.

to check to see if it would work, but I don't see why not. >> >> >>-- Ben Doom >>Programmer & General Lackey >>Moonbow Software, Inc >> >>: -Original Message- >>: From: James Blaha [mailto:[EMAIL PROTECTED] >>: Sent: Tuesday, Ju

Re: I need some good old advice.

27;t see why not. > > >-- Ben Doom >Programmer & General Lackey >Moonbow Software, Inc > >: -Original Message- >: From: James Blaha [mailto:[EMAIL PROTECTED] >: Sent: Tuesday, July 15, 2003 12:04 PM >: To: CF-Talk >: Subject: Re: I need some good old

RE: I need some good old advice.

not. -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: James Blaha [mailto:[EMAIL PROTECTED] : Sent: Tuesday, July 15, 2003 12:04 PM : To: CF-Talk : Subject: Re: I need some good old advice. : : : Jim, : : Thanks for the reply. I'm not s

Re: I need some good old advice.

Jim, Thanks for the reply. I'm not sure I totally follow you. Are you saying to just do a normal cache with a timeout on the main query and place the updates and deletes on the cached query? At what point do I update the actual database table affected? Regards, JB Jim Davis wrote: >Sorry -

RE: I need some good old advice.

Sorry - not much time but... If the updates and deletes are simplistic (and rare as you say) you _might_ want to not redo the whole main query, but rather update it as well. Remember that you can modify any query in memory using all the variable manipulation tools at your disposal. That way you