Upper Limit on Rowcount

[Former Member]

Hi All

We recently had an issue where the interface need to transfer 145000 rows but MII transferred only 120000 rows, that figure rings a bell about the upper limit on rowcount that MII query template has. Is that the max no of rows that MII can pick?

Thanks

Rupesh

[Former Member · Accepted solution]

Rupesh,

if you are using MII 12.1 >= SP10 or MII 12.2 >= SP4, then you can change the limit of the RowCount

from 120.000 to xxx.xxx under AdminMenu -> System Management -> System Properties -> Maximum Rowcount.

Please keep in mind, that increasing of the parameter will slow down the query.

BR

Pedro

[former_member204240 · Accepted solution]

Hi Pedro, Its nice to know that we can change the limit.

But is this is limited only to certain versions and SP that you have mentioned?

[Former Member · Accepted solution]

Padma,

the possibility of changing the Maximum Rowcount is added to MII with the SP mention above.

BR

Pedro

[former_member204240 · Accepted solution]

Okay, I was really not knowing this.Thanks for the update.

[Former Member]

Thanks Pedro

This is good to know, and glad that the the version that we have has this option.

Only thing I will have to check is, increasing the count here should not affect the performance of queries which are not expecting big amount of data.

Regards

Rupesh

[rutika_bodas]

Hi Rupesh,

What you can do is, after setting a maximum limit on the number of rows that MII queries can return using the property on System Management screen, locally overwrite this number on the queries which are not expecting big data on the 'General' tab, in 'Row Count' property.

In other words, setting 'MaxRowCount' property on the System Management screen sets it for all queries globally. But you can overwrite this property locally for each query also, in the 'General' properties tab of your queries on the WorkBench and set the property 'Row Count' for those queries which are not expecting data as big.

Thanks,

Rutika

[Former Member]

Rutika,

keep in mind, that you can't return more records as the limit that you specify on the System

Mgmt screen. The setting on the template will only take effect, if the specify values is less

then the System Mgmt value.

BR

Pedro

[rutika_bodas]

Hi Pedro,

Yes, I had observed that . Thanks anyway.

-Rutika