Archives of the TeradataForum
Message Posted: Tue, 02 Jun 2009 @ 14:12:24 GMT
| Subj: | | Re: MLOAD performance problem |
| |
| From: | | Wu Yuren |
Two things you need to check, do you have error records in the error table. Usually that is the first place you want to look when you diagnose
such issue. If a lot error records being generated, your performance will be abysmal, since error table is taking on record at a time.
If that is not the case, use a Fastload to load the data into a empty table, check what's wrong on the primary index.
NULLs or something like varchar(2k) in your PI will likely cause problem. Mload acquiring phase is actually fastlaod data into a work table
with a system defined primary index, your large varchar field with a lot of empty string is likely to cause problem.
| 
