Archives of the TeradataForum
Message Posted: Sat, 01 Dec 2012 @ 09:11:23 GMT
| Subj: || || Re: Ideal TPUMP Sessions |
| From: || || Dieter Noeth |
Roopalini Bakthavachalam wrote:
| ||Thanks for the response. I ran tests with various combinations of PACK and SESSION factor. I noticed that having SESSION = 20 / SESSION
=40 didn't make any difference. Below are the results I got for 1.1 Million records.|| |
| ||PACK = 20 and SESSION = 2 - It took 2.5 hours PACK = 20 and SESSION = 20 - It took 17 minutes|| |
Enable ARRAYSUPPORT and increase the PACK as high as possible, but when using multple sessions you probably need to switch on SERIALIE, too.
You should get much higher throughput with less sessions.