Like Hamid Said, if the ColdFusion server has the query already in memory.
It doesn't need to send traffic to another server to get the information
again. Most systems I've worked on have the db and the web server on
different areas of a firewall, so you're going through a lot of excess steps
if
in any case.
[Marlon Moyer]
Because most CF servers are installed on the same web server, no wire is
required between the web server and cf server.
Plus, you have a granular control on what is being cached. The sql
server
will only cache what it has room for. So if enough queries are run
I don't have a problem with this method. It would be nice though to be able
just set 1 application variable and be done with it.
-Original Message-
From: John W. Holmes
Marlon Moyer wrote:
But I think the original question was about a tree that took a long time
to
create
, stock changes, specials, updates from places like TechData,
etc. If I'm caching the results of my query, I miss those updates, and
have a customer placing an order for a product at the wrong price, out
of stock, etc.
[Marlon Moyer]
This isn't a situation that you would use a cached query
to agree with them.
[Marlon Moyer]
ColdFusion allows you to store variables in several different scopes
including Session, Application, and Server. You already know session
variables. Application variables only exist within a specified application
and can have a timeout specified. Server variables
5 matches
Mail list logo