Richard White wrote: > ... found that at present coldfusion query of queries just isnt built as a > database engine And probably never will be. That is what ColdFusion engineers told a group of us at a pre-Max conference a couple of years ago. ColdFusion is *NOT* a database engine and is not being designed to replace one. Q-of-Q is only designed for simple tasks.
> ... 'what if i changed into an array of arrays and replicated my query but > with manual cf code'. And this is exactly what they suggested for heavy data lifting inside of ColdFusion. As apposed to a database engine designed around SQL and query record sets, ColdFusion is optimized to use arrays and structures. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312678 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4