Millions of records on reactive application
Question

Hi,

What is the recommended approach (performance wise) to show records from a database table with millions of rows on a reactive web application? 

The application is supposed to used on multiple devices (phone, tablet and desktop)!


Thanks!



Solution

Hey there!

The best approach(what I think and what I always do) is the approach that OutSystems already give to you, which is to fetch by a number of records and have pagination, that way you are not getting all the data, but just a number of records defined by the max records, using pagination.

https://success.outsystems.com/Documentation/11_x_platform/Developing_an_Application/Design_UI/Patterns/Using_Mobile_and_Reactive_Patterns/Navigation/Pagination

If you move an entity to a screen you will see it's going to create a page detail and page with a list, you can see how the list is being created, with pagination and the aggregate with the start index, max records, action to paginate and the sort.

Kind Regards,

Márcio

Thanks Márcio!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.