I am required to display thousands of data from 2 tables. Does having a pagination help with the query speed. Does it only get the first page of the data or does it get everything from the aggregate?
Hi Jeremy,
Did you try already?
Important is to not have a filter condition in your aggregate that requires a full table scan like using the "like" on a text attribute or a search on an attribute that is not indexed.
For more information see also this discussion;
https://www.outsystems.com/forums/discussion/40983/how-to-fetch-10-records-per-page-on-click-of-pagination-from-outsystem-entity/
Regards,
Daniel
I think the way you should go is create the input search into your screen like this example
Yes pagination speeds performance.
Just fetch only 10-20 records at time from query instead of fetching all.
Best
Arun