RE: maxrows and blockfactor

2001-07-09 Thread Peter Tilbrook
-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

RE: maxrows and blockfactor

2001-07-09 Thread Raymond Camden
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

Re: maxrows and blockfactor

2001-07-09 Thread Chris Norloff
-- Original Message -- From: sebastian palmigiani [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sat, 07 Jul 2001 16:28:06 -0500 What is the difference between maxrows and blockfactor? Both are available with cfquery but only blockfactor is available

RE: maxrows and blockfactor

2001-07-09 Thread Raymond Camden
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. ===

RE: maxrows and blockfactor

2001-07-09 Thread Dave Watts
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.

maxrows and blockfactor

2001-07-08 Thread sebastian palmigiani
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

RE: maxrows and blockfactor

2001-07-08 Thread Dave Watts
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

RE: maxrows and blockfactor

2001-07-08 Thread Christopher Olive, CIO
://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