Oracle ODBC driver Pre-fetch problem with 8.1.78 Driver
187722May 2 2003 — edited May 5 2003Hi all,
I'm having a strange problem with my Oracle ODBC Driver. I had the Oracle 8.1.74 ODBC driver on my system, and I upgraded to the 8.1.78 driver. After doing this, I noticed that my network packet count has gone up doing simple queries. It seems with this driver, that the driver is not pre-fetching any data. I also noted that in the 8.1.78 driver that the prefetch count has been replace by a prefetch buffer size. Is there a bug with the 8.1.78 ODBC driver ?
Or do I have to configure the Pre-fetch buffer size differently than the Pre-fetch count ? I've left the size at the default of 64000 - I assuming that means 64000 bytes = 64K.
Thanks,
Nick.