> This is from the April 2000 edition of CFDJ. Article; In Defense of
> MS Access, By Bruce Van Horn:
>
> First, add the Blockfactor="100" attribute to all your CFQUERY tags.
> This alone will dramatically increase the speed of your queries.
> Without this attributes, when you run a query, ODBC hands the
> retrieved records back to the CF server one at a time. By adding this
> attribute, ODBC will keep the records and then hand them off to CF in
> blocks of 100 at a time, which is much faster.
I don't think you'd always want to simply set BLOCKFACTOR to 100. If you set
the BLOCKFACTOR too large, the database driver will lower it - and I'm not
sure exactly how it figures out what to lower it to. It might simply lower
it back to the default value of 1, which won't serve you well.
Allaire recommends that you divide your maximum record length into 32Kb; I
suspect they recommend this because you might not get optimal performance
otherwise. I could be wrong about this, though. I don't know enough about
how things work at that relatively low level to be sure one way or the
other.
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
