Question

Understanding SQL Retrieval in Mendix Data Grid Pagination

0

In Mendix, data grids are commonly used to display large datasets with pagination feature. When users navigate to the next page within a data grid, the application needs to fetch the corresponding data efficiently. Does this action initiate additional SQL retrieval ?

asked 2024-02-12

Naga praneetha Varada

1 answers

Pieter Scherphof · Accepted Answer · 2024-02-12

Yes, it will do an additional retrieve. You can see for yourself by putter the Log node ConnecitonBus_Retrieve to Debug (or Trace). You will see something like:

RequestAnalyzer: incoming request InternalLimitedXPathTextGetRequest (depth = -1, offset = 60, amount = 20): //PartyDataManagement.Party

which queries my PartyDataManagement.Party table by retrieving 20 rows with an offset of 60 (moving to page 4)