Product specifications

The value set in the cs.cfg file.

Default

11.3.4 Array Fetch Size

Specifies the number of rows of data retrieved per slice. Connection

Server provides array fetch capability in any deployment mode.

Remember:

The Array Fetch Size value is propagated to the database middle-

ware if it supports array fetch.

The optimal number depends on the performance of your system:

• If the number is low, the system retrieves small amounts of data

many times. This can affect performance.

• If the number is high, the system performs fewer retrieval operations,

but it requires more memory for each one.

Caution:

Make sure the Array Fetch Size value is appropriate because it

can affect the performance of your system, especially in remote access,

for example when connections to SAP ERP system are established in

a web tier deployment mode. For OLAP connections in remote access

(MS Analysis Services, SAP BW, and Essbase data sources through

32-bit Connection Server), set the array fetch size to an optimal value

depending on the number of columns in reports to be created (for exam-

ple 100 if the number of columns is high, and 250 if the number is low).

Note:

In a web tier deployment mode, the HTTP Chunk Size parameter can

also help you to fine-tune the performance by reducing the number of

data calls between the client and the server. See the

SAP BusinessOb-

jects Business Intelligence platform Administrator Guide

for more infor-

mation about HTTP chunking.

Description

2012-03-15125

SBO parameter reference