Guidance Needed for Optimizing Performance of a Large-Scale Mendix App

0
Hello Everyone,   I’m currently working on a large-scale Mendix application designed to handle a high volume of concurrent users and complex data processes. While the app functions well in development and testing environments, we’ve noticed significant performance drops during load testing. I’m reaching out to gather insights and best practices from experienced Mendix developers on how to optimize performance for such applications.   Here are some specifics about our setup and the challenges we’re encountering: App Overview: The app uses several large entities with millions of records. We rely heavily on associations and custom microflows for business logic. Performance Issues: Slow response times when fetching data for pages with high record counts. Increased latency in executing microflows with complex logic. Occasional timeout errors under heavy concurrent user loads. What We’ve Tried: Optimizing XPath constraints to reduce unnecessary data fetching. Indexing database fields frequently used in filters or queries. Testing microflow logic with smaller datasets, which improves performance marginally.   Despite these efforts, we’re struggling to achieve the scalability and responsiveness needed for production. I’d greatly appreciate advice on: Efficiently handling large datasets and reducing database load. Best practices for microflow design to ensure faster execution. Using Mendix’s built-in performance monitoring tools effectively. Any tips or success stories related to scaling Mendix apps for high user demand. Thank you in advance for your insights and suggestions! Looking forward to learning from the community’s expertise. Daisygenerative ai
asked
1 answers
0

It is very hard to give you clues without knowledge of the domain model and data. It seems you already tried a lot of stuff. My advise is to pinpoint the locations where the app is slow. In a datagrid for instance you could not show the total count for instance because that already could slow the datagrid when there are a lot of records. Also check the search fields and especially the search fields that contain references.

In your logs you will see the retrieves that take a lot of time. Try to analyse why these retrieves take so much time. Analyse the XPath queries and double check if they can be made simpeler.

 

And after you pinpointed alld the chokes you always could get paid advise from Mendix Expert services. They have a lot of experience with these kind of problems, but indeed it will cost you but your developers will learn a lot from these people.

 

Regards,

Ronald

answered