Archives of the TeradataForum
Message Posted: Fri, 30 Nov 2012 @ 14:46:52 GMT
| Subj: || || Re: Ideal TPUMP Sessions |
| From: || || Newell, Ray |
48 sessions is to many. Tpump is not a bulk loader like Multiload. Each packet sent down will have to be parsed, just like if you were
submitting an SQL statement. With Tpump, my experience has shown that setting the pack factor to an optimum number is the best way to improve
performance. There are no standard settings, you just have to test various settings to find the optimal valves.