> What is the difference between maxrows and blockfactor?
>
> Both are available with <cfquery> but only blockfactor is
> available with <cfstoredproc>.
MAXROWS specifies the maximum number of rows. BLOCKFACTOR specifies the
number of rows that CF will attempt to store in the database driver's
storage buffer upon each row fetch. The two don't have anything to do with
each other. The buffer is 32 Kb, so you can figure out how many rows
(assuming the maximum possible row length) can fit into the buffer, then
specify that number as the BLOCKFACTOR attribute value. This is a
performance enhancement; it makes getting the data faster. It doesn't affect
how many rows will be returned by your query.
> Can you use blockfactor with a <cfstoredproc> the same way
> that you would use maxrows in <cfquery>?
No, but you can use MAXROWS with CFPROCRESULT, which will have the same
effect as using it with CFQUERY.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
