[thelist] ColdFusion Application Variables

Aaron Johnson lists at cephas.net
Thu Feb 6 16:06:18 CST 2003


Hi Seth,

> > -----Original Message-----
> > I'd suggest creating the structures in the request scope, and
> > making sure that the code that does so is executed on every request.
>
> The values for the most of the application variables come from the
> database, in two separate queries; the reason for placing the data into
> persistent variables in the first place is to avoid having to hit the
> database two more times on every page load.
 -- why not cache the queries and then copy the results of the query into
request scope...? caching the query for n hours would then effectively cut
out the db hits AND you gain the performance of not having to lock to gain
access to application scope.

AJ

Aaron Johnson
http://cephas.net/blog/
ajohnson at cephas.net





More information about the thelist mailing list