 |
 |
Archives of the TeradataForum
Message Posted: Mon, 02 Dec 2002 @ 22:41:43 GMT
| Subj: | | Re: Sessions vs AMPs vs Data |
| |
| From: | | Madhu Reddy |
Comments are embedded
| | 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. | |
Is following formula is only for FastLoad? IS this applies for MultiLoad and Tpump also?
| | 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. | |
I got following message from my Fastload Job output for table1
**** 16:32:29 Number of recs/msg: 690
**** 16:32:29 Starting to send to RDBMS with rec
**** 16:32:29 Sending row 77
**** 16:32:29 Finished sending rows to the RDBMS
Here RM is 690
AM i correct?
| | 2. Calculate the average number of records for a single load. Call this value AR. | |
How to calculate this?
| | 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. | |
How to calculate this without using Excel?
| |
