Hi,
This may be old question but asking it again, could not find in search.
According to documentation the Oracle connector stage offers better functionality and performance replacing some stages which have been deprecated. Is there a real functionality difference in the way the oracle connector stage and enterprise stage connects and calls Oracle statements?
I assume both the stages in 8.5 writes the data in array and writes using Oracle host-array processing. If both use the same method of writing to database, is there a real performance difference (other than functionality)?
Oracle Connector Stage
Moderators: chulett, rschirm, roy
Oracle Connector Stage
Thanks, EthanR
-
priyadarshikunal
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Oracle connector is said to be 20% faster than oracle enterprise stage as it uses its own API while the oracle enterprise stage uses Oracle clients API. Although the oracle connectors API still uses the oracle libraries but not the application.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.