Mega Code Archive

 

Categories / Delphi / ADO Database

 

Oracle 7 faster than oracle 8

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.