 |
 |
Archives of the TeradataForum
Message Posted: Fri, 10 Mar 2006 @ 21:02:24 GMT
| Subj: | | Re: MLoad session calculations |
| |
| From: | | Victor Sokovin |
| | Is it better use Session 20 instead of mentioning session 20 4 for large volumes of data load ( 4 million records) | |
| | sessions 4 for small volumes of data load ( less than 10000 records) | |
Not always. Just run a number of tests on your particular system and find your own optimum. I've seen cases when 4 4 was just fine for both
10,000 and 4 million records. This could be an indication that something else is not optimal, though. But if for whatever reason you can't further
improve performance by increasing the number of sessions, it is just better to keep that number as low as possible.
Regards,
Victor
| |
