Hello, All!
I have a quick question :
I am currently working on a ColdFusion application for a client of mine, and
had a question about efficiency.
Scenario :
I have dozens of news articles, how-to guides, etc. that are all text-based
and currently stored in a db in memo fields. These articles could be
accessed often, and the same user may view several of these in one sitting
(session).
Question :
What is the most efficient way to access this info?
1) Create a session-scoped array to store the titles and copy for the
articles. (Running the query only once.)
2) Simply cache the query.
3) Let the user hit the db every time the page loads and they request a
document.
My goal here is to maximize efficiency and minimize db access. I imagine
that if I have dozens of simultaneous users, that creating session arrays
might be taxing to the server. Conversely, if I hit the db server every
time the user requests an article, is this excessive?
Setup :
ColdFusion 4.5 Server
Access 2000 (development)
SQL Server (production)
Any ideas, thoughts or comments?
Thanks in Advance!
Christian N. Abad
ColdFusion Developer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
