maxReturnedRow limitation

Classic Servoy
1

Let say your result consists of 400 records and in servoy you have mentioned maxReturnedRows=200 then no way you can see the complete data. You will miss 200 records.Is there any way to increase maxReturnedRow dynamically?

Also for dynamic queries you will not know how many records the query will return. Increasing the maxReturnedRows to a very large number will return all the records but will make applications slower.

Any suggestions?

2

Hi soumyamahakul,

I assume you are talking about a foundset and the controller only fetching batched of 200 records at a time.
When you place the controller at record 200 it will automatically load another batch of 200 records (PK’s actually), and so on.
So by ‘scrolling’ through your records it will fetch all 400 records it had found in the first place.

Hope this helps.

3

Hi Robert,

I am using getDataSetByQuery function. The column which I am searching is not the primary key.
Finally I am displaying data in HTML format. I am not using the scrolling functionality.

In my situation I am find x based on condition.Based on number of x s I have to find y s. Based on y s I have find z s.
So I am using nested queries which makes the application slower.

Som

4

Hi Som,

You can set the maxReturnedRow value to -1 so there is no limit on the records it will retrieve (other then RAM).

Hope this helps.

5

Thanks Robert,

This is what I was looking for. You are a genious.

Many thanks
Som