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.