Thanks!
My concern was that some of the discussions suggested to me the buffer size
might be fixed at 32Kb rather than variable.
best, paul
At 07:14 PM 11/23/00 -0500, you wrote:
> > 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
