ColdFusion Tutorial
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" > |
ColdFusion Tutorial test
Increasing the performance of CFQuery
No test is available or implemented for this ColdFusion Tutorial.
No User Comments.
No User Comments, be the first one to write your comments?
