-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
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.
By the way, did you know if you pass -1 to MAXROWS, it will return
maxrows is the maximum rows the query will return.
blockfactor is how many rows are returned per database call. a query returning 100
rows with a blockfactor=1 (default) will make 100 database calls. with
blockfactor=100 (the maximum) it will make one database call.
Chris Norloff
Thanks for the tip; I didn't know this. Apparently, neither do
the folks who
write the CF documentation. You might want to share it with them.
Well, it is missing from the CF4.x docs, but it does exist in the CF5 doc.
===
Thanks for the tip; I didn't know this. Apparently, neither do
the folks who write the CF documentation. You might want to share
it with them.
Well, it is missing from the CF4.x docs, but it does exist in
the CF5 doc.
Right you are! It's nice to see the inexorable march of progress.
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
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]
7 matches
Mail list logo
