I have been reading in many places to increase performance, increate the BLOCKFACTOR of queries to 100.If I have a query that generally returns 5 rows should a blockfactor of 100 benefit, hurt, or not affect performance.
I have tried using the blockfactor in the past by going through the app and
I have been reading in many places to increase performance,
increate the BLOCKFACTOR of queries to 100.If I have a
query that generally returns 5 rows should a blockfactor of
100 benefit, hurt, or not affect performance.
I have tried using the blockfactor in the past by going
through
CF Docs on the Subject are as follows:
"Optional. Specifies the maximum number of rows to fetch at a time from the
server. The range is 1 (default) to 100. This parameter applies to ORACLE
native database drivers and to ODBC drivers. Certain ODBC drivers may
dynamically reduce the block
CF Docs on the Subject are as follows:
"Optional. Specifies the maximum number of rows to fetch at a
time from the server. The range is 1 (default) to 100. This
parameter applies to ORACLE native database drivers and to ODBC
drivers. Certain ODBC drivers may dynamically reduce the block
I get to 100 all the time. For example, I use Verity to get
a list of Record IDs whose data matches my search term, and
then use SQL with CFQUERY and BLOCKFACTOR = 100 to filter
the VERITY result set.
Of course, in this case any savings in having BLOCKFACTOR greater
than 100 is probably in the
5 matches
Mail list logo