Here's something to think about when programming for scalability: If you have a query, and you execute that query a thousand times in 1 minute, how many times does the data returned by that query change?
More importantly, if it changes, how important is it that the change be displayed to the end user the instance that change occurs? Query caching is your friend. Of course sometimes that's not enough. So then you have to think.. well, if I load this page 1000 times in a minute, how often does it change? Then, you start writing out static files and writing scheduled tasks that update the static files every minute.. or whatever. Programming for scalability is about reducing repetition of CPU and database intensive operations. When you post something to craigslist, it doesn't appear on craigslist for up to 15 minutes.. that's because they're writing out static files for the categories and stuff. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306634 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
