It's better to CACHE! That's not always true though. It depends on your
server's hardware, and what you are doing. The kinds of queries you should
cache are ones that do not change very often, such as category tables.
Don't cache a query like SELECT * FROM table WHERE Itemid = #var# which
could cause every row in the table to get cached in a separate query, that
will not improve performance (it could on a small table though). For those
cases you could store the entire table in a server, or application scoped
structure, and access them like #server.tblname[id].fieldname# this is an
excellent way to go. You Also may not want to cache too many queries it
could hog all your server memory. So you are going to need to do some
testing of your own to figure out which works better for your server
hardware.
_______________________________________________
Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com/
-----Original Message-----
From: Bill Killillay [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 06, 2000 2:26 PM
To: Cf-Talk
Subject: Cached Query's?
If I cache a query, does that mean that on the server that same query gets
cached for every user that hits the site, or is it cached once when the
first user hits. Which is better, to cache it or not.
Bill Killillay
ICQ @ 8425781
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
"An investment in Knowledge always pays the best interest."
-Benjamin Franklin-
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Get Paid to Surf the Web. It's free, easy and fun.
Sign up for AllAdvantage.com at
http://alladvantage.com/go.asp?refid=FIB-034
Most of us are on it every day all day anyway, why not give
yourself a pay raise for 25 hours a month.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
