Increasing the performance of CFQuery

Adding BLOCKFACTOR = "100" to your CFQuery tags can greatly improve the performance of your ODBC queries. Default ODBC hands recoreds back to ColdFusion 1 at a time. This setting allows ODBC to sent them in blocks of 100. The attribute works great even on smal queries with less than 100 records.

 

Example:

<cfquery blockfactor="100" datasource="your_db" name="users_info" > SELECT * FROM USERS </cfquery>

Advertisement

No User Comments.

No User Comments, be the first one to write your comments?