> Having read some more of your replies, I think I would recommend just > re-running the select every time. 10's of thousands of records really > isn't that large of a result for a well-endowed SQL server to transfer > around. The big question is how long it takes to generate them. > Analyze your execution plans for starters and see if improvements can be > made there.
I'll second this - you're not going to get the in-memory caching in CF that you need for something like this. You may want to investigate using an OLAP cube for this sort of data instead of a standard OLTP database, although interacting with this from CF will probably be more complicated. I'm not so sure how I feel about the phrase "well-endowed SQL server", though. *bow chicka wow wow* Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsit ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331369 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
