If you are setting an application variable, it will be maintained for
the runtime of the app (i.e. until the server restarts). Why do you need
to rerun the query on every page view? Is the data static or does it
need to expire after a certain timeframe?
How about...
<cfif not structKeyExists(application, "myQuery")>
<cfquery name="application.myQuery"...
</cfif>
-----Original Message-----
From: Richard Colman [mailto:[EMAIL PROTECTED]
Sent: Thursday, 15 September 2005 11:01 a.m.
To: CF-Talk
Subject: Query in application.cfm
I need to keep track of a production system configuration. So, is is OK
to put a query into application.cfm, like:
--> Do a query into production settings table
--> set application variable depending on query results
--> drink a beer ;-)
Are there any issues, other than a query that runs every time a page is
executed and perhaps slows things down just a bit ... Would it be
quicker to read a file with CFFILE to get the application variable value
than run a very simple query??
Richard Colman
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218336
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
