> How large are buffers set to? I often use
> BLOCKFACTOR=100 in a query where I:
>
> SELECT ID FROM foo WHERE bar
>
> Is this setting a large buffer?
The size of the buffer will depend on the maximum size of a returned row.
Given that you're using a field called "ID", which is probably an integer,
your maximum row size will be 4 bytes. One hundred rows of 4 bytes each will
take 400 bytes, which will be a small fraction of the maximum buffer size of
32,768 bytes.
In summary, don't worry about it!
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
