Archives of the TeradataForum
Message Posted: Tue, 07 Feb 2001 @ 01:21:11 GMT
| Subj: || || Re: Insert vs. Multiload |
| From: || || James Judge |
Don't have the facts but as a comparison we do a single session CLI insert of 400+K rows in about 45 minutes on a 5200 (that's about what
150 rows/sec; rowsize about 120bytes. ran also with 5 NUSI's on table in 90 minutes. We run MLOADS of about 3M rows on the 4 node 5200 in
about 18 minutes; adding 1 NUSI added about 33% to elapsed; same row size & 64KB blksize. Obviously there is an area where either is
acceptable; so it mostly depends on the batch administration, data availability for querying, and more complex index usage.
Attached is four slides (a little dated but good reference). In your example the size of the configuration would be a consideration. If
I had to guess I would use CLI inserts (perhaps TPUMP for multiple sessions and the batch functionality of MLOAD) to keep the table
available and the fact that you are most likely updating a very low % of DB (data blocks).