Re: Pro*C Array Fetch Question

As
Does that mean Pro*C would receive the whole  500 records at one time ?
Yes.
what happens when Pro*C runs on
 the same host as the database server ? they still use SQLNet ( Ur right)

Dogan Cibiceli <dcib_at_gwl.com> wrote in article <37093B98.C916B26B_at_gwl.com>...
> Hi,
> I have a simple but nagging question in my mind. Suppose I am fetching
> into an array of size 500. Does that mean Pro*C would receive the whole
> 500 records at one time OR does Pro*C wait till 500 records are fetched
> ? What am I wondering is that, is the number of records sent by lower
> level constant ? For example always 20 and Pro*C waits until 500 is
> fetched. If that's the case, Shouldn't it be better to utilize the lower
> level buffer to the full and fill it up to max and send it at one time ?
> For Ex. TCP/IP MTU is 1536 and rec. length is 40 bytes (simp. sake ass.
> constant rec. length) that would mean I can put around 30-40 recs in one
> packet and send it. If this is the case, what happens when Pro*C runs on
> the same host as the database server ? If they still use SQLNet, it
> shouldnot matter much because internal comm. is much faster ? Right or
> wrong ? I know too many questions and should have changed the subject :)
> Thanks in advance...
>
>
> Dogan
>
>
Received on Wed Apr 07 1999 - 16:58:45 CEST