content_image/745442.jpg content_image/745451.jpg content_image/745452.jpg content_image/745453.jpg
of number of records ( BatchSize ) and in terms of bytes ( BatchByteSize ). The actual batch size is limited by both parameters. 

The speed at which queries are performed can vary by more than 40% depending upon how this parameter is set. 

This parameter is measured in bytes. The default value is 16K. 

• BatchSize 

<img src='content_image/745442.jpg'>

This parameter is measured in number of records and is by default set to 256. The maximum size is 992. 

• ExtraSendBufferMemory 

<img src='content_image/745451.jpg'>

This parameter specifies the amount of transporter send buffer memory to allocate in addition to any that has been set using TotalSendBufferMemory , SendBufferMemory , or both. 

• HeartbeatThreadPriority 

<img src='content_image/745452.jpg'>

Use this parameter to set the scheduling policy and priority of heartbeat threads for management and API nodes. The syntax for setting this parameter is shown here: 

HeartbeatThreadPriority = policy [, priority ] policy : {FIFO | RR} 

When setting this parameter, you must specify a policy. This is one of FIFO  (first in, first in) or RR  (round robin). This followed optionally by the priority (an integer). 

• MaxScanBatchSize 

<img src='content_image/745453.jpg'>

