Surely it would. It a little known attribute that can have big returns on large recordsets. It does make CF take a bigger chunk of memory(for obvious reasons), but the performance gains you see in your query times make up for it. For smaller recordsets, it can have minimal effect however. Maybe I'll put some demos together to show its use and speed. .djc. "Walker, Matthew" wrote: > > > 'blockfactor' attribute does.. 'Blockfactor' tells CF how many rows to > > fetch at a time from your DB server. > > This is interesting. So surely it would be better to use a setting other > than the default? Why not set it to a really big number so that CF only > makes one trip to the ODBC server? Something I'm missing??