Pagination load

is there a way for mendix to only load a certain rows instead of all when opening the page,,, so if i want to show the data with datagrid for example when i open the it only load the first 20 rows and next page and so on instead of load the data, because im using database connector if im showing the data which has 50k rows it will load for a very long time so i have to do pagination where it load some data first untul user clicking next page,, is there a way ?
1 answers

This documentation explains how to using paging with a microflow datasource:

The example uses it with a REST call, but you should be able to do the same with the database connector. The SQL statement you execute can using LIMIT x, OFFSET y expression to specify which records are needed (syntax depends on the database you're using).