# Max Row Index Count

**URL:** <https://forum.servoy.com/t/max-row-index-count/2819>\
**Category:** Classic Servoy\
**Created:** [October 1, 2004, 2:25pm UTC](https://forum.servoy.com/t/max-row-index-count/2819 "2004-10-01T14:25:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ebrandt](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@ebrandt](https://forum.servoy.com/u/ebrandt)\
**Post date:** [October 1, 2004, 2:25pm UTC](https://forum.servoy.com/t/max-row-index-count/2819/1 "2004-10-01T14:25:02Z")

</div>

What is the difference in the these two ways of getting the complete found set count;

globals.Number1 = .getMaxRowIndex();

globals.Number1 = databaseManager.getFoundSetCount();

I know the second is an expensive operation, but I have little choice the few times that users need to return more then 200 records.

Also, the mehod editor say there are syntax errors with both these.

Thanks.  
Erich

---

<div class="post-metadata">

**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\
**Post date:** [October 1, 2004, 3:32pm UTC](https://forum.servoy.com/t/max-row-index-count/2819/2 "2004-10-01T15:32:39Z")

</div>

> ebrandt:  
> What is the difference in the these two ways of getting the complete found set count;
> 
> globals.Number1 = .getMaxRowIndex();

with controller.getMaxRecordIndex() you get the maximum number of rows in your foundset but limited to the (pre-)loaded rows. So at first you have 200 (or less if you have less rows). If you loaded above that you get the above in chunks of 200…

> globals.Number1 = databaseManager.getFoundSetCount();

databaseManager.getFoundSetCount(foundset); counts all records

> I know the second is an expensive operation, but I have little choice the few times that users need to return more then 200 records.
> 
> Also, the mehod editor say there are syntax errors with both these.

See my answers above. That will give you the right syntax… And, check your sample code in Servoy.

Cheers

---

<div class="post-metadata">

**Author:** ![ebrandt](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@ebrandt](https://forum.servoy.com/u/ebrandt)\
**Post date:** [October 1, 2004, 3:54pm UTC](https://forum.servoy.com/t/max-row-index-count/2819/3 "2004-10-01T15:54:53Z")

</div>

Muchas Gracias