Databases have long served as the lifeline of the business. Therefore, it is no surprise that performance has always been top of mind. Whether it be a traditional row-formatted database to handle millions of transactions a day or a columnar database for advanced analytics to help uncover deep insights about the business, the goal is to service all requests as quickly as possible. This is especially true as organizations look to gain an edge on their competition by analyzing data from their transactional (OLTP) database to make more informed business decisions.
ESG compared a SPARC T7 server with a single SPARC M7 chip vs an x86-based server with a dual-chip E5- 2699 v3 query performance on a 179GB in-memory compressed database using RCDB. When doing analytics, the SPARC M7 leverages an on-chip data accelerator that handles decompression, scanning, and result return in a single step. Compared with an x86-based E5 v3 system that contained more chips and more cores, the Oracle SPARC T7 with an M7 processor yielded impressive performance results and higher levels of efficiency with more computational power.