> And for the most efficiency, why not just always use
> BLOCKFACTOR=1000000 ?
The maximum allowable value for BLOCKFACTOR is 100, according to Allaire.
> Why is the default the most inefficient choice?
The default will always work. The ability to specify larger record blocks
isn't universally supported, and may cause CF to generate an error on
platforms which don't support it.
> Is there any advantage in uses a lower number?
You'd always want to set this to the maximum number of rows that you can fit
into 32Kb. Potentially, if you set it to a higher number than that, it might
not do anything for you.
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
