Archives of the TeradataForum

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

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

Hi,

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.

Cheers,

Dave

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

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