While looking for ways to leverage available memory to cache data (and reduce database I/O), consider also the CACHEDWITHIN and CACHEDAFTER attributes of CFQUERY. They can provide you the benefit you seek without the need to worry about building structures and arrays to "cache" the resultsets.
/charlie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Shane Von Svoboda Sent: Wednesday, February 13, 2002 3:35 PM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] CF Structures Thanks Bob, I would really appreciate if I could get some examples. I have been monitoring out web server's memory and I have concluded that memory is hardly ever used to it's potential. In most cases with a Gig of RAM only 10 - 15% is ever used. I would like to change my coding practices so I can push more data in memory as mentioned below. -----Original Message----- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 3:23 PM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] CF Structures I use structures extensively, quite often for doing just what you describe - caching database information in the server memory so I don't have to go back to the database for info that I know won't change regularly (like values in code tables). My understanding is that CF also processes structures and arrays faster than text strings, so if you are looking to boost performance, and you are storing anything in a list, you might see an improvement by using a structure or an array instead of a list. I'm a bit busy right now with a deadline, but I'll post some examples of stuff I've done with structures within the next day or two (or perhaps someone will beat me to that). Any specific questions you may have I'd be happy to try to answer. Bob > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Shane Von Svoboda > Sent: Thursday, 14 February 2002 8:51 a.m. > To: [EMAIL PROTECTED] > Subject: [CFTALKTor] CF Structures > > > I have a question about Structures. Does anyone use structures > extensively through their CF code besides the use of ColdFusion's > Session, application, cookie variables etc...? There seems to be more > and more emphases on getting as much data from a database and storing it > in memory where it can be easily accessed and manipulated the quickest. > There seems to be many different ways of creating structures and > combining them with arrays and other structures but I find them a little > complex. In most situations I have never needed the use of structures > and I was wondering how much they are used. I'm trying to find as many > ways to code my CF templates so I get the best output performance from > ColdFusion Server. > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "Shane Von Svoboda" > <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) > http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Bob Silverberg" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Shane Von Svoboda" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "charles arehart" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
