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>>