Devart Forums

Hi,

While migrating from Informix to SQL SERVER 2005 database, I have changed Informix Data Access Components (IDAC) by SDAC.

During this migration, at some places ‘FetchRows’ property of MSQuery components got changed from its default (25 rows) to 1 row.

Do you foresee any impact of this particular change as a whole?

I am using liecensed 3.80 version of SDAC components.

Regards

The value of the FetchRows property can have a great impact on performance.
It indicates the number of rows that will be transferred across the network at the same time.
So it is preferable to choose experimentally the optimal value of the FetchRows property for each SQL statement and software/hardware configuration.