Archives of the TeradataForum
Message Posted: Fri, 02 May 2003 @ 15:46:00 GMT
<-- 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|