Dave:
I think/hope we're saying the same thing.
Re-writing your sentence below to state it to my understanding:
"What you don't want to do, according to the folks at Allaire, is use a
value for BLOCKFACTOR, where BLOCKFACTOR multiplied by the row size exceeds
32Kb."
I also thought BLOCKFACTOR had a maximum value of 100.
best, paul
At 01:37 PM 11/20/00 -0500, you wrote:
> > I assume this means you don't set BLOCKFACTOR in those cases
> > where doing so would slow CF down. (That is, those cases where
> > the data returned exceeds 32K.)
>
>There's nothing wrong with using BLOCKFACTOR when you're returning datasets
>larger than 32Kb. In fact, that's the best time to use it. What you don't
>want to do, according to the folks at Allaire, is use a value for
>BLOCKFACTOR which would end up being larger than 32Kb. So, you find out the
>maximum length of a single row in Kb, and divide that into 32Kb.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
