IIRC, blockFactor is only relevant on the Oracle drivers, and it refers specifically to how Oracle expects to batch and return large recordsets. If Oracle is allowed to spool out large recordsets without returning them in blocks, it will often spin the DB server out of threads, which then cascades to the waiting app threads ... and then things die. Blockfactor, therefore, controls how the DB server batch responds to the request, but it does not impact how CF brings data back into its CFQUERY struct.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:320277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
