Interestingly enough, on your "reduce the load on the database and shrink the amount of data being sent back and forth.", that's where I started to look at late this morning, I was investigating on the possibility of using the new SerializeJSON family tag for data query, was wondering about the cost of serialization and diserialization and array sets... vs. current query structure... has anyone done some experimentation on this?
On db design etc. pretty confident... Some cf8 best practice would be good (blogging, not bad but lots of fragmentation...) >If you are looking at where to focus your optimization efforts, start >with database queries. Do whatever you can to reduce the load on the >database and shrink the amount of data being sent back and forth. Also >make sure you have the proper database indexes set up. > >In nearly every case where I am asked to help speed up Web sites, the >problem comes down to poorly designed databases or sub-optimal >database queries. Although increasingly I am seeing Web services as >being a bottleneck. > >Good luck, >Mike Chabot > >On Feb 18, 2008 6:52 PM, D >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
