cancel
Showing results for 
Search instead for 
Did you mean: 

Upper Limit on Rowcount

Former Member
0 Kudos
348

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
Active Participant
0 Kudos

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
0 Kudos

Padma,

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

BR

Pedro

former_member204240
Active Participant
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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
Participant
0 Kudos

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
0 Kudos

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
Participant
0 Kudos

Hi Pedro,

Yes, I had observed that . Thanks anyway.

-Rutika