>Fifteen hundred records isn't very many. > >Query of queries is relatively slow, so I wouldn't be surprised if that >approach is slower than just querying the database at runtime for each >product. > >Generating output on the first runtime hit (with CF_ACCELERATE or CFCACHE) >will generally provide the best performance if you have a lot of cache hits. >CF_ACCELERATE is very memory-dependent, of course, so you'll have to be >careful there. CFCACHE is very bad if you don't have many cache hits.
>Generating static HTML through custom application logic provides the best >performance, obviously, but at the cost of not being able to use dynamic >stuff at runtime. I already auto-update a cfinclude (html only) for the homepage blog entries and new products pod. I could do that for categories I guess, just have to work out the auto-updating. That's obviously the fastest, don't know why I wasn't thinking of that. I'm not sure about search though. I have search results set up to display products just as a category would, not just links, and provide a lot of search links, like tags really, to bring up various product classes. And of course what anyone searches for. Maybe best to leave to the cachedwithin tag? Thanks for the tips. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
