Archives of the TeradataForum
Message Posted: Tue, 06 Jul 2004 @ 10:33:45 GMT
Subj: | | Re: Oracle Application Gateway Performance Benchmarks |
|
From: | | Victor Sokovin |
| Request all of you who have had experience with oracle application gateway to share your observations / recommendations / experiences. I
need a mechanism to quantify the following. | |
| Response times observed for TB and above of data moved through the gateway while performing loads. | |
| Response time for ad-hoc / canned queries run against tables in Oracle joined with HUGE tables in Teradata | |
| It would definitely help if someone can also share their experience for using / not using the gateway / an alternate success story of
making the two DBMS talk! | |
John has compiled a few useful threads on the subject:
www.teradataforum.com/teradata/20030522_141615.htm
Probably not a lot changed since then. I wouldn't expect great performance if I had to pull terabytes of data from TD to Oracle via the
gateway.
Regards,
Victor
|