|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/26/2007 10:02:00 AM
Posts: 5,
Visits: 1
|
|
Just i would like to know the reason, in what way fast load will perform better than multiload when we are loading empty tables?
Regards, Syam Prasad K
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 4:25:28 PM
Posts: 534,
Visits: 284
|
|
Hi Syam,
the Acquisition phase of MLoad is comparable to a FastLoad into the Worktable (i don't know about the internals, but it's probably using the same technique). And there's some additional information sent to the worktable, the Match Tag, so the rowsize is larger for MLoad.
For FastLoad worktable and targettable are the same, but within MLoad there's the Application phase inserting data from worktable to targettable, this is additional work, too.
Dieter
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/26/2007 10:02:00 AM
Posts: 5,
Visits: 1
|
|
O.K,Thank you
Just to know ,is there any impact that Mload will work with secondary indexes and fast load should n't work with?
Regards, Syam Prasad K
|
|
|
|