Salesforce

Array Size - Database Property (Magic xpa 3.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Array Size - Database Property (Magic xpa 3.x)

The Magic xpa gateways to SQL support array processing. When retrieving rows from the database, the gateway does not retrieve one row at a time, but retrieves a group of rows, which reduces network traffic.

Although Magic xpa uses its own array size of rows, these numbers can be revised. When scanning a large table, increasing the array size can enhance performance. It is recommended, however, to use the Magic xpa default. The default should be changed only in special cases.

The array size is copied to the data source property only when you create a new table.

Relevant interfaces: MSSQL, Oracle, DB2, IBM i and Space (IMDG)

Default value: 0

Reference
Attachment 
Attachment