SingleStore is the fastest database ever tested by us
Updated October 25, 2021
SingleStore is the fastest database ever tested by us
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with SingleStore (formerly MemSQL)
We are using SingleStore as our primary analytics database within our own platform (called "Pulse"). The Pulse platform is used primarily in Siemens internally, but is also available to enterprises outside of Siemens.
We offer end to end reporting & analytics services and use SingleStore to power our dashboards and reports.
We offer end to end reporting & analytics services and use SingleStore to power our dashboards and reports.
Pros
- Performance.
- SQL-interface.
- Relational online analytical processing (ROLAP).
Cons
- SQL completeness (e.g. triggers).
- Performance tuning insides.
- Increased customer satisfaction.
- Increased possibilities.
- Increased user engagement.
We have tested various SQL databases including SQL Server, PostgreSQL and MySQL (in different flavors) and SingleStore is easily 20x faster than any of them; depending on the query we have even seen 100x improvements for analytics queries. An analytical query on Aurora MySQL that takes 40s to run runs in <100ms on SingleStore without changes to query.
Fast query and real time analytics certainly have a positive impact on user/customer satisfaction, but predictive analytics are achieved through ML models.
We have increased our license size over time and have increased our cluster both through vertical as well as horizontal scaling. When we know there is going to be peak traffic, we have also increased sizes proactively just for a couple of days. Because more CPUs usually result in higher concurrency, SingleStore can easily scale by just adding more CPUs to the cluster.
Do you think SingleStore delivers good value for the price?
Yes
Are you happy with SingleStore's feature set?
Yes
Did SingleStore live up to sales and marketing promises?
Yes
Did implementation of SingleStore go as expected?
Yes
Would you buy SingleStore again?
Yes
Using SingleStore (formerly MemSQL)
3000 - Users from all functions you SingleStore, but not directly but as users of applications that heavily depend on SingleStore.
5 - Our in-house people that support the SingleStore operations have an IT background. Skills required are:
- Basic Linux command line skills.
- Basic SQL skills.
- Infrastructure skills (setting up servers and firewalls).
- Analytics.
- Self-service.
- Business intelligence.
Comments
Please log in to join the conversation