Re: Peformance degradation during array fetch in Pro*C

Are you reading the entire table into the array, or just bits of it at a time?

If it is the entire table, try performing the read but not storing the data - this might help determine if it is the database or the Pro*C that is the bottle neck.

ETA lcrusader_at_yahoo.com (Oracle User) wrote in message news:<47cd09c.0303220646.5cfecc20_at_posting.google.com>...
> Hi guys,
>
> My program uses host arrays in Pro*C to read data from oracle db. The
> size of the table is arbitrary and ranges from 0 - 10 mil records.
>
> The program worked fine for small tables, but for larger tables,
> performance was poorer than sql*plus spooler. So, I traced the timings
> between each fetch and found that as the program fetched more and more
> rows, the time to fetch the same number of records also grew, from 1
> sec to 15 secs. Since the delay is from the server, I couldn't find
> any way to improve my program.
>
> Is there any way to overcome this hurdle? I have tried the program
> with different array sizes, with the same result. My program uses
> Dynamic SQL and connects over sql*net. I have seen some posts pointing
> to the network connection as a culprit. But that doesn't answer why my
> fetches are faster in the beginning and slower towards the end?
>
> Any help is greatly appreciated.
>
> Thanks.
Received on Fri Mar 28 2003 - 10:18:18 CET