Question:
I've noticed that fetching data against Oracle 7 is faster than Oracle 8. How come?
Answer:
If you are not using Object types the Oracle 8 driver can see improved performance turning off OBJECT MODE in BDE Administrator.
The Oracle 8 driver performs at the same level as Oracle 7 driver when the Oracle 7 driver has ROWSET SIZE set to 1.
However, the Oracle 7 driver can have marked performance by increasing this parameter. The Oracle 8 driver does not support this
parameter at this time and so therefore cannot reach the performance of the Oracle 7 driver at this time.