Optimize read only listviews for performance (start using schemas just like datagrids) - Mendix Forum

Optimize read only listviews for performance (start using schemas just like datagrids)

19

These days listviews are used a lot as 'datagrids'. Since the datagrid Flex headers widget is EOL there is only one way to create flexible grids with a good UX; and that's to use listview combined with the listview controls widgets.

There is only one pretty big issue. In contrast to a datagrid, a listview is firing all the join table queries which will make the UI a lot slower.

Example: Let's imagine an entity Invoice. Invoice has 10 associations as owner in the data model.  

Implementing this as datagrid: will result in 1 query to retrieve only the columns shown in the grid. 

Implementing this as listview: will result in 1 query to retrieve Invoices with all columns + it will execute 10 queries PER row to read the join tables. Having 20 rows on your screen the listview will execute 200 extra queries

So the feature request is: support schema based retrieval of listview data for read only (to keep it simple) listviews

asked
1 answers

@Herbert, was this request implemented in 7.21 ?

https://docs.mendix.com/releasenotes/desktop-modeler/7.21#microflow-association-source-improvements

Cheers, Andries

Created