>> It gets a connection from the pool, queries the DB, retrieves all the data and finally returns the connection to the pool.
Well, I'm stunned. I was sure CF was better designed than that. I thought that data was retrieved as loops were going. Obviously course, with 300k records, CF is reading all data from disk, from a system especially designed to handle and retrieve data, put it back on disk, and then gets it back again into memory as loops goes. This is ridiculous. Even dBase was designed to retrieve data by chunks only when needed. I can't believe this. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:320265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
