Mload Vs Fastload

Tools
Enthusiast

Mload Vs Fastload

Hi,

Which utility is faster Mload or Fastload if we are loading data into an empty table and why?

Can we load duplicates into a multiset table with a NUPI using Mload?

Thank You
3 REPLIES
Enthusiast

Re: Mload Vs Fastload

Hi,

For loading data into a empty table, FastLoad is the efficient one.
Enthusiast

Re: Mload Vs Fastload

FastLoad is generally faster when loading an empty table because FastLoad was designed specifically for that purpose. FastLoad can sort the incoming rows directly into the target table, whereas MultiLoad first sorts the incoming rows into a worktable and then applies the worktable to the target table.

MultiLoad fully supports mulltiset tables with duplicate rows.
Enthusiast

Re: Mload Vs Fastload

hi,

Having empty table, fload is best bcz of in fload we have 2 phase only but mload 5 phases......
so performance wise fload is best......for empty tables only...

we can load duplicate data into multiset in mload