What is the difference between Multiload & Fastload interms of Performance?

Showing Answers 1 - 4 of 4 Answers

sudha

  • Sep 27th, 2006
 

Fast Load: to load empty tables at high speed.

MLoad: to insert,update and delete up to 5 different tables or views.

rajajana

  • Dec 7th, 2007
 

If you want to load, empty table then you use the fastload, so it will very usefull than the mutiload..because fastload performs the loading of the data in 2phase..and it noneed a work table for loading the data.., so it is faster as well as it follows the below steps to load the data in the table

Phase1-It moves all the records to all the AMP first without any hashing 
Phase2-After giving endloading command, Amp will hashes the record and send it to the appropriate AMPS .

Multiload:

It does the loading in the 5 phases
Phase1:It will get the import file and checks the script
Phase2:It reads the record from the base table and store in the work table
Phase3:In this Application phase it locks the table header
Phase4:In the DML opreation will done in the tables
Phase 5: In this table locks will be released and work tables will be dropped.

  Was this answer useful?  Yes

SHUBH25

  • Feb 15th, 2008
 

As the name suggests Fasload is faster than multiload, and whenever required to load an empty table fastload should be preferred.
However, Fastload has some limitations.

To perform Fload:
1. Target table must be empty
2. Fload performs inserts only (no updates)
3. Only one target table at a time
4. Must drop secondary indexes before loading and recreate them afterward

Multiload allows nonunique secondary indexes - automatically rebuilds them after loading

Shubhangi

  Was this answer useful?  Yes

Aryan R

  • Oct 26th, 2010
 

Fastload
1) Loads one table at a time
2) It does not load duplicate data.
3) Table should be empty.
4) Runs 2 phases.
5) It does not run in modes.
a) Import mode.
b) Delete mode.
6) It needs 2 error tables.
7) It does not support NUSI table
8) It applies Access lock on target Table during loading.


Multiload
1) Loads up to 5 tables at a time.
2) Does not mind loading duplicate data.
3) Loads the data into the Table whether it can be either empty or full.
4) Runs 5 phases.
5) It runs in 2 modes.
6) It needs 2 error tables, 1 restart log table and 1 work table.
7) It supports NUSI table loading loading.
8) It applies write lock on target Table table during loading.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions