Hi,
In our project we are using Oracle enterprise stage. While reading from Oracle I saw it is reading 33000 rows/sec. But in some jobs while inserting it is 33 rows/sec to 100 rows/sec. It is very slow. And the operation at target table is Upsert.
This is a sort of performance improvement project. Can anyone help me out to figure out where I can explore more for this type of slow rows/sec.
Cheers
Deb
Slow Oracle enterprise stage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Update is always - and necessarily - a slow operation. Even insert can be slow if there are many indexes and integrity constraints to be checked.
Separate your inserts and updates into separate streams, bulk load the inserts and do the updates subsequently.
Separate your inserts and updates into separate streams, bulk load the inserts and do the updates subsequently.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.