Question and Answer Database FAQ: FAQ4669B — Oracle 7 faster than Oracle 8 Category: Database (Oracle) Platform: All-32Bit Product: All-CBuilder, BC++5.x, C++Builder1.0, C++Builder3.x, C++Builder4.x, Delphi2.x, Delphi3.x, Delphi4.x, VdBase7.x, 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. 7/13/99 10:52:06 AM
Last Modified: 01-SEP-99