Archives of the TeradataForum
Message Posted: Tue, 15 Sep 2015 @ 09:02:47 GMT
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|