Can the ArraySize parameter in the odbc.ini be set to higher value like 1 GB?

Can the ArraySize parameter in the odbc.ini be set to higher value like 1 GB?

book

Article ID: KB0088973

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Resolution:
Environment
----------------
All

The default value for ArraySize is 60000bytes.

The driver will allocate this size of memory while executing a select statement, regardless of the size of the return result set.
It depends on the available memory of the machine at the time the driver allocate this memory.

Setting the ArraySize to a  large value might  cause memory allocation issues, and the behavior is hard to predict.

TIBCO Adapter for ActiveDatabase throw the below error if the ArraySize is high
Publisher: exception thrown in ADBDatabaseInterface::handlePollCommandRequest().

Issue/Introduction

Can the ArraySize parameter in the odbc.ini be set to higher value like 1 GB?