if you had 10000 rows for a queryNew() query you were going to construct to store in memory from a cfc to a display layer template but you could logically break that down to 5 queryNew() queries, of 2000 rows each, one for each vehicle in this instance and store them, would you be better off performance wise when displaying them?
cause id only need to show 1 of them at a time the other 4 would still just be hanging out in memory if i stored them all id prolly use a query of query to get the data for the individual ones, and then display that new query... on the other hand, i would just be reading its specific query and not making that qofq call. which would be best performance wise of top of ya head?/ thanks! -- tony Better than a thousand hollow words, is one word that brings peace. -- siddhartha gautama ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:278149 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
