Usage of IPC stage
Moderators: chulett, rschirm, roy
Usage of IPC stage
If I use an IPC stage between a DRS stage and a hash file, will it improve the performance. I'm trying to load data from an Oracle DB table containing around 3 million records into a hash file and it took around 30 minutes, I want to improve upon this.
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Do you use all the records you are loading into the hash file?
If not then doing a lookup without a hash file would improve your performance.
Please post your scenario, So that people can help you better.
There are a lot of ways to improve your current performance, if you can post the exact scenario.
If not then doing a lookup without a hash file would improve your performance.
Please post your scenario, So that people can help you better.
There are a lot of ways to improve your current performance, if you can post the exact scenario.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Are you using Static or Dynamic Hashed files?
Wrong settings in Static hashed files can reduce the performance drastically.
Wrong settings in Static hashed files can reduce the performance drastically.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>