BLOCKFACTOR is how many rows are returned along the pipe at one time from
the query. for example, if you have BLOCKFACTOR set to 50, and the query
would return 400 rows, the DB sends the rows along the network pipe in
blocks of 50.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-----Original Message-----
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 07, 2001 5:28 PM
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
