Stephan Bruijnis .dev


Fast manipulation of large tables

Jul 13, 2017
Performance, Batch processing, Transactions, Best practices

Mendix applications can accumulate large sets of data originating from various sources and created for various reasons. In order to work efficiently with large datasets extra attention to performance is needed. This post will provide recommendations for speed and performance when modelling manipulations of large datasets. Use batches (limits and offsets) # Batches are the execution of actions each on a set or “batch” of inputs, rather than a single input. ...

Use Cast Object to get the specialisation

Aug 17, 2016
Inheritance, Performance, Best practices

The Mendix platform queries the entire hierarchy when retrieving the specialisation from the database, in order to guarantee a consistent data structure. When retrieving the generalisation it will also retrieve the entire hierarchy. Thus, developers should never retrieve a specialisation from database if the generalisation is already available. Use Cast Object with an inheritance split to get the specialised members of the object. This is much faster. Inheritance # A specialisation is an entity that inherits attributes, associations, events etc. ...

The developers guide to performance

Jan 31, 2016
Performance, Optimization, Database, Microflows, Best practices

Update Nov 2021 The Mendix documentation offers two good guides on performance best practices: Implement Community Best Practices for App Performance and Performance Best Practices. Both worth the read, and they are kept up to date by Mendix and the community. This blog post is from 2016 and has a lot of information that is still relevant today. But I’m unable to update to update all links and best practices in this document with every new Mendix release. ...