We successfully copy the data from our Progress 9.1D business application database to MS SQL Server for reporting purposes. Using DataDirect as the ODBC driver, the Progress database becomes a Linked Server of the SQL Server. Several of the Progress tables contain over 1,000,000 rows.
We have been using the default ArraySize setting of the ODBC driver. The default is 50 which corresponds to retrieving 50 rows per fetch. I have read documentation examples in which the ArraySize is increased to 200. I want to know if there is an upper limit to the ArraySize, and, also, whether there may be adverse effects of setting the ArraySize high - say up to 16,000.
Thank you.
We have been using the default ArraySize setting of the ODBC driver. The default is 50 which corresponds to retrieving 50 rows per fetch. I have read documentation examples in which the ArraySize is increased to 200. I want to know if there is an upper limit to the ArraySize, and, also, whether there may be adverse effects of setting the ArraySize high - say up to 16,000.
Thank you.
