The InterSystems Caché 2015.1 data platform represents a new generation of ultra-high-performance database technology. Optimized to take advantage of modern multi-core architectures, Caché 2015.1 running on the Intel® Xeon® processor E7 v2 family provides a robust, affordable solution for scalable, data-intensive computing.
This Intel white paper describes testing performed by performance e...ngineers from InterSystems and Epic. The test team found that Caché 2015.1 with Enterprise Cache Protocol (ECP) technology on the Intel Xeon processor E7 v2 family achieved more than 21 million end-user database accesses per second (known in the Caché environment as Global References per Second or GREFs) while maintaining excellent response times. This was more than triple the load levels of 6 million GREFs achieved by Caché 2013.1 on the Intel® Xeon® processor E5 family.
These tests and others help Epic develop comprehensive sizing guidelines and ensure reliable, productive experiences for the users of its electronic medical records (EMR) software. Epic’s test program is designed to reflect realistic, meaningful work scenarios of large healthcare enterprises.
Epic’s and InterSystems’s performance engineers performed a series of tests to validate the level of throughput that Caché 2015.1 could achieve while maintaining acceptable responsiveness. Test engineers also compared the scalability of Caché 2015.1 and Caché 2013.1. The testing used real Epic applications and their associated database code. Client-side user loads were synthetically created by Epic simulation tools to run against the database. Both test environments were configured to Epic’s best practices for Caché ECP configurations. Both ran Red Hat Enterprise Linux* and VMware vSphere* virtualization software.
With ECP running on the Intel Xeon processor E7-4890 v2, the test team calculated that Caché 2015.1 sustained nearly 22 million database accesses per second on a diverse application server compute environment consisting of 140 CPU cores and a total of around 440 GHz of processing power. This works out to a very impressive figure of approximately 50,000 database accesses per second per gigahertz of compute. Testing stopped at 22 million database accesses per second because the test team ran out of hardware, not because that figure represents any type of scalability wall.
InterSystems Caché 2015.1 and the Intel Xeon processor E7 v2 family offer an outstanding and affordable solution for mission-critical, data-intensive computing in healthcare and in other industries.
The Intel Xeon processor E7 v2 family combines performance and cost-effectiveness with enterprise-grade scalability. Intel’s product road map highlights ongoing advances in the performance and capabilities of the Intel Xeon processor E7 family.
For healthcare organizations, the combination of InterSystems Caché 2015.1, Epic EMR software, and the Intel Xeon processor E7 v2 family provides an enterprise-class solution for rising volumes of EMR data, genomics data, and other sources of data growth. These three robust technologies enable organizations to accommodate the mergers, acquisitions, and collaborations that are further swelling the size of their healthcare databases.