Array Size - Database Property (Magic xpa 2.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 and IBM i

Default value: 0