Archives of the TeradataForum

Message Posted: Fri, 22 Nov 2002 @ 17:59:36 GMT

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

Hi,

Based on our experience with FastLoads, and attempting to maximise the performance bu minimise the number of sessions, I calculated a formula to work out the number of sessions a FastLoad script should use.

1. Calculate the number of records contained within a message (64K Block). This is output as part of the FastLoad logs. Call this value RM.

2. Calculate the average number of records for a single load. Call this value AR.

3. Calculate the average number of message blocks required to be transferred. Call this value AM, which is calculated as ROUNDUP(AR / RM, 0) within Excel.

4. NM = Number of AMPs on your system.

5. IF ((AM / 100) is less than NM) THEN Number of Sessions = AM / 100 ELSE Number of Sessions = NM

I hope you find the above useful.

Regards

Matthew Winter

Technical Architect
TPG IS Design Authority
Teradata Certified Professional

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