Home > Workload Solutions > Oracle > White Papers > Unleash the Power of Real-time Data Intensive Applications > Dell validation
The Dell Technologies database engineering team tested SingleStore functionality and performance. The goal of the SingleStore validation work was to improve customer outcomes. We used a PowerEdge R940xa for the validation tests. The PowerEdge R940xa configuration included:
VMware vSphere virtualized the primary and secondary aggregator nodes and three leaf nodes:
We used the TPC-DS benchmark to create a decision support dataset for testing. The goal was to gain an understanding of how SingleStore supported complex queries with the decision support data that is distributed across the three leaf nodes. Our results indicated that it took 17 minutes and 42 seconds to complete 98 complex queries.
Lessons learned during testing include the following:
These lessons learned, and other best practices will accelerate SingleStore deployments and provide an optimized data management platform.