> What is the best time to use cachedwithin? Would it be good to > use on lets say a message board? I am using Dain Andersons > colorcoded tag, and it takes awhile to parse everything if their > is alot of html in the query output. I was thinking of maybe > caching it if that is a good idea.
The best time to use CACHEDWITHIN is whenever you have a query that is called frequently enough that, if you cached it, it would very likely be reused. This is a very common situation, and can be found within many applications, including message boards. Caching a query won't save any time in the part of your code that loops over the resultset, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
