Главная страница | назад

Article #19669: Oracle 7 faster than Oracle 8

 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,   


I've noticed that fetching data against Oracle 7 is faster than Oracle 8. How come?


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