Archives of the TeradataForum
Message Posted: Fri, 02 May 2003 @ 15:46:00 GMT
| 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.
| 
