Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 02 May 2003 @ 15:46:00 GMT


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


Subj:   Bundling Data in Macro Calls
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, May 02, 2003 10:50 -->

We bundle our data when we make our macro calls to Teradata. By that I mean we will send down XX requests in a single call. We have a method for determining the number of requests, where we keep adding more data until we receive

3710 - Insufficient memory to parse this request, during Optimizer phase.

But we are receiving disparately different results on 2 different machines. On a single-node 4455, 6 PE, 3 AMP we can send 23 parcels of data in one call. On a 2-node 4855, 16 PE, 12 AMP we can only send 9 parcels. Why is there such a big difference between the 2 machines? I would have thought that we would be able to send more parcels on the 2-node machine.

Thanks.



     
  <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: 27 Dec 2016