If you’re a regular reader of our Data Excellence blog, you may remember that last summer we introduced the InterSystems Speed Test, validated by ESG and designed to test how much data databases can ingest and query at the same time, and how this impacts performance. Many visitors to our GitHub page have been testing the kit out to their own specifications since.
Initially, the first iteration of the database Speed Test compared InterSystems IRIS data platform alongside popular databases from a number of different cloud and data management vendors. Excitingly, we can now announce that we have extended the database performance testing from SAP HANA, AWS Aurora MySQL, SAP Sybase ASE, and AWS RDS SQL Server to also include PostgreSQL, MariaDB, and Oracle Enterprise, all running on Amazon Web Services (AWS).
Why run the open source Speed Test?
By simulating a multi-workload use case that doesn’t favor any particular product, the Speed Test acts as another performance testing tool on which to base decisions around which database or data platform best suits a business’ needs. As many organizations continue to undergo digital transformation and explore replacements for legacy technology, this capability is proving critical.
The nature of the database Speed Test means you can easily run it for yourself on the cloud or on your machine and, since we’ve released the test as customizable open source code, it can be extended to your own data and queries.
Seen by many as the platform of choice for microservices, the open source speed test is now also available to run on Kubernetes in recognition of the application’s increasing popularity among the InterSystems developer community. This means as well as being able to use AWS and Amazon Elastic Kubernetes Service (EKS), developers can see how InterSystems IRIS performs on Kubernetes clusters and make use of the InterSystems Kubernetes Operator.
How does InterSystems IRIS stack up against the competition?
The Speed Test looks at the specific use case of simultaneous ingestion and query performance, which is a fundamental requirement of real time use cases in many industries, such as finance, supply chain, and manufacturing.
The results of the latest Speed Test found that when compared to AWS MariaDB –InterSystems IRIS ingested 620.9% more records during the test and ingested them 717.3% faster by the end. Comparing the performance of InterSystems IRIS with Sybase ASE running on a public cloud found that InterSystems IRIS ingested 4862.8% more records during the test and was ingesting them 6733.4% faster by the end of the test.
For any organization looking to modernize its infrastructure to improve database performance for real time and near real time applications, these metrics are extremely important. In addition, for those companies that have production applications running on SAP Sybase ASE, InterSystems native support for Transact-SQL allows for seamless migration of these applications, often without needing to rewrite custom code.
Don’t just take our word for it, visit our GitHub page to put InterSystems IRIS to the test yourself or find out more about the how the Speed Test works here.