Here's a follow up question. Imagine a situation where you pass a list of
IDs to a query. You know that the query will only return, at most, the same
# of rows as IDs. Taking the same kind of query, where the amount of bytes
returned per row divided into the buffers size would tell us to use 100 for
blockfactor, would you still use 100 if the # of IDs was < 100?
=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Allaire
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 23, 2000 7:14 PM
> To: CF-Talk
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: Dave Watts please read - Re: BLOCKFACTOR and MAXROWS
>
>
> > 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.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
