Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 15 Sep 2015 @ 09:02:47 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: API load vs Fastload
From:   Dave Wellman


I agree, I'd expect Fastoad to load much quicker than SQL INSERT statements. I think the way to tackle this is to work out why FL is running slowly.

1) Are you able to get the FL log from the job? That will show you whether the time is taken in phase 1 or phase 2.

2) If the time is taken during phase 1, how many sessions are being used? How many sessions inuse for the 'api load' job?

3) For this job, how wide are the rows being loaded? If you are dealing with ** very ** wide rows then FL may not give you any real advantage.

4) What is the checkpioint rate for the FL job? If this is too low then it will often slow the job.



Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023