If I understood correctly, he's saying that if you're caching the query in a
shared location (ie 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
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 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 - 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 get the updated data in your query but don't incur
: the refresh
: >time (or at least as much of it).
: >
: >The main query will still be rerun on it's scheduled
: out-of-cache time. So
: >periodically you'd get the "real thing".
: >
: >Jim Davis
: >
: >
: >
: >>-----Original Message-----
: >>From: James Blaha [mailto:[EMAIL PROTECTED]
: >>Sent: Tuesday, July 15, 2003 10:10 AM
: >>To: CF-Talk
: >>Subject: I need some good old advice.
: >>
: >>All:
: >>
: >>I need some good old advice. I'm redesigning an application to utilize
: >>query caching and the use of Query of Query to speed it up some. So I'm
: >>caching one large query and running the application templates using Q0Q.
: >>Any time there that there is an insert, update or deletion from the
: >>database I'm going to un cache the main query. The QoQ's will always
: >>have correct data as changes happen which shouldn't be all that often.
: >>
: >>My question is when I perform a SQL insert, update or delete is there a
: >>way to call and run a query but not have that query add to the execution
: >>time of the template. For example maybe and idea is calling a scheduled
: >>job to run the query.
: >>
: >>Regards,
: >>James Blaha
: >>
: >>
: >>
: >>
: >>
: >
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
