<img height="1" width="1" style="display:none;" alt="" src="https://px.ads.linkedin.com/collect/?pid=1195114&amp;fmt=gif">
HOME
/
9,000% performance increase with Mendix on SAP HANA cloud

9,000% performance increase with Mendix on SAP HANA cloud

3 September 2020, last update 17 June 2021 1 min read

This blog is about the '9,000% Performance Increase with Mendix on SAP HANA Cloud' video, presented by Nolan Ramsey and Greg Sprowles, Mendix. You can watch the video here.

SAP HANA is an in-memory, column-based database system that offers extremely high performance by removing the overhead of an entire IO layer that comes with in-database systems backed by hard disk. Instead of a hard drive, what you get is a RAM-packed blade appliance. This improvement is comparable to what SSD technology did for conventional PCs.

To test the performance of a Mendix application on SAP HANA, they set up a simple dashboard showing aggregates of 77 million records. The same app is deployed to SAP HANA and to a Mendix Sandbox node. Both application environments are filled with the required sample data.

Have you ever repeatedly clicked a button every 30 seconds to set up some test data? Well, they did to set up the Sandbox environment.

Where can you get these 9000% performance improvements that they are talking about? The number actually tells us that SAP HANA is executing the same query about 90 times faster than on the Sandbox. You won’t be surprised to hear that this performance gain does not apply across all use cases. 

There are several other use cases, e.g. running an OQL group by query. This query is still almost 10 times faster on SAP HANA, which is a significant performance improvement. Keep in mind that these performance improvements are linked to database read operations.

One thing that you should remember from this session is true independency of the database. You will get far better performance on complex aggregate queries when using OQL instead of the commonly used retrieve + aggregate pattern. So be sure to take a look at the OQL module in the AppStore.

As a Mendix developer, you don’t need to worry too much about the actual database. So you can use the same data grids and logic that you were using before.But do be careful when handling such big data sets. Feeding them to a data grid through a microflow data source may get you in trouble.

Conclusion

If you are moving towards big data processing like social media mining or working with IOT data, you should definitely look into the possibilities. Integrating the Mendix platform with the SAP cloud environment has certainly meant a step forward.

Even though comparing SAP HANA against the smallest possible Mendix cloud database is not an entirely fair comparison, I’m looking forward to seeing how well this performs in a real-life scenario.

 

New call-to-action

START TODAY

Ready to accelerate your digital transition?

Get in touch Get in touch
Fabian Recktenwald Fabian is a consultant at CLEVR and has more than 7 years of experience in software development. As an expert developer, he brings his specialist knowledge to bear in a wide variety of projects.

Related articles

Read the latest CLEVR news, articles and updates on LinkedIn
Receive personal news and updates in your inbox