>>Indeed, while the initial query may take longer, it is perhaps better performing than hitting the db on each iteration within the request. Thoughts?
Perfectly right for small result sets. But as soon as the virtual memory must be used, each record will generate some read-write-reread action, pretty bad on performance indeed. IMHO, CF should should be able to "buffer" the record set, ie. read a certain number of records until a certain amount of memory is full, then do as usual if the whole record set fits in memory, and read the next buffer when needed. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-talk/message.cfm/messageid:320284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
