-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Both MAXROWS and BLOCKFACTOR are optional attributes for CFQUERY.
MAXROWS allows you to define the maximum rows retrieved each query
(eg: 10). If you leave out MAXROWS the query will return all records
in the database matching your query. This could be thousands so
maxrows can be handy.
BLOCKFACTOR 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 factor at runtime. As I
understand it blockfactor can be used to boost the performance of a
query (the database server does the work) but I'm not sure how.
- -----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of sebastian
palmigiani
Sent: Sunday, 8 July 2001 7:28 AM
To: CF-Talk
Subject: maxrows and blockfactor
What is the difference between maxrows and blockfactor?
Both are available with <cfquery> but only blockfactor is available
with
<cfstoredproc>.
Can you use blockfactor with a <cfstoredproc> the same way that you
would
use maxrows in <cfquery>?
Sebastian Palmigiani
- --------------------------------------------
Cash Flow Club Charity
http://www.cashflowclubonline.com/?SEB007883
voice: 773.929.9256
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists