Hi,
here in my scenario we are facing the performance problem because of Universe tables are used as look up tables.
In my scenario only we are using Transformer, look up Hash files, look up tables and sequential files.
Now it was loading the data with 20 rows/sec
need to load 900000 records..
Could some one help us..
Thanks,
vv
Performance issue in Server job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Any SQL-based lookup will be slower than hashed file lookup.
Greater speed can be had if the columns mentioned in the WHERE clause are indexed; without that you are potentially performing a full table scan for each row processed.
Greater speed can be had if the columns mentioned in the WHERE clause are indexed; without that you are potentially performing a full table scan for each row processed.
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.