This content has been marked as final. Show 3 replies
How was the performance in comparison. Reason why I am asking we did a POC and we saw huge difference in performance. We are using ORACLE 9i.
Like, an input with 1 million records that reads a VSAM file and does some processing being change to go to ORACLE database.The logic is pretty simple trying to access each record from the oracle Db as the existing program is doing. Oracle DBA has also confirmed the query is using the required indexes
Mainframe using VSAM to process 1 Million - 2.5 Elapsed Minutes, .30 CPU secs
Mainframe using VSAM to process 1 Million - 150 ElapsedMinutes, 25 CPU minutes.
1. Did you experience any network latency issues
2. Do I need to check the mainframe SRVCLASS priorities
3. Any specific strategy to followed (Partioning,caching etc).