How to retrieve 5 records from database which is having 2 lakhs records

0
suppose, I have 2 lakhs records in my database, How can I retrieve first added 20 records from the database table. is there performance issue occurs, How can we handle it using batch process. Can I know how we can implement batch Process to retrieve large amounts of data.
asked
1 answers
2

If you want to retrieve the first 20 records from the database table, you can use the “custom” range option in your retrieve action, as shown below:

Docs about that can be found here: https://docs.mendix.com/refguide/retrieve/#332-range 

We also have some docs about retrieving in batches: https://docs.mendix.com/howto7/monitoring-troubleshooting/detect-and-resolve-performance-issues/#batches 

Hope this helps! 

answered