Pro*C Array Fetch Question
From: Dogan Cibiceli <dcib_at_gwl.com>
Date: Mon, 05 Apr 1999 16:39:20 -0600
Message-ID: <37093B98.C916B26B_at_gwl.com>
Hi,
[Quoted] 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...
Date: Mon, 05 Apr 1999 16:39:20 -0600
Message-ID: <37093B98.C916B26B_at_gwl.com>
Hi,
[Quoted] 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 Tue Apr 06 1999 - 00:39:20 CEST