> Ok... say I'm using a stored procedure that is, in this case,
> calling several other stored procedures to return multiple results
> sets back to cold fusion to reduce the number of round trips to
> the database... Anyone know if I would calculate the BLOCKFACTOR
> by adding up the lengths of all the columns for all the sprocs
> that are called by the main calling sproc or would I use the
> length from the widest sproc of the bunch...?
If you're setting a BLOCKFACTOR for a single stored procedure which returns
multiple recordsets, you'll want to set it to the maximum number of the
longest records that may be returned, and will fit within the 32 Kb buffer.
So, just use the length from the "widest" recordset returned.
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
