Is there any solution to suppress memory on Data Grid widget without accessing database?

0
On Data Grid widget, we would like to handle a huge size of data with pagination.  This works fine for connection from database but not nice for Microflow.  This is because it consumes a lot of memory with a huge data from Microflow.   Is there any solution to suppress memory on Data Grid widget without accessing database?
asked
2 answers
1

Perhaps using data sets is a solution. Create an OQL query specifying the above and show the result in a report.

https://docs.mendix.com/refguide6/data-sets

However, a report is readonly so if you want to use the data you're retrieving, you might have to take a different approach. 

answered
0

We would like to do the followings:

1) mapping from one entity member to 2 or more members,

2) joining multiple entities into one entity like SQL's 'JOIN', and 

3) grouping entities and summing up data like SQL's 'GROUP BY' and 'SUM'

answered