> According to the article by Mr. Van Horn, any Oracle or ODBC 
> datasource supports blockfactor. Is that not true?

I don't know for sure.

> > Also, setting a block factor too high when it is not needed 
> > will hurt performance because allocating and freeing those 
> > larger buffers takes time (and takes memory away from where 
> > it could be more efficiently used).
> 
> Well, how can you know when it's needed? Obviously, when doing a 
> search, you may return 1,000 records, or you may return 1.

You won't be able to exactly determine the optimal value for each use.
You'll have to estimate.

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

Reply via email to