[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: using -B flag
- Subject: Re: using -B flag
- From: Donald Raikes <draikes@PRIMENET.COM>
- Date: Thu, 19 Sep 1996 13:58:08 -0700
At 02:33 PM 9/19/96 -0400, you wrote:
>What constitutes the use of the flag -B and how do you determine how many
>rows to buffer?
>
>Thanx
>
>Bob.
>
>
Bob,
Use the -b flag on a begin-select when you are reading large quantities of
data. To determine how many rows to buffer, use trial an error. Start with
100, then 1000 etc to find a reasonable level of performance.
Contact me if you have more performance questions.
Don Raikes
draikes@primenet.com
http://www.primenet.com/~draikes
====================================
Donald Raikes CPIM
EaglesWing
Making Oracle Fly
draikes@primenet.com http://www.primenet.com/~draikes
===========================