SingleStore is the fastest database ever tested by us
Updated October 25, 2021

SingleStore is the fastest database ever tested by us

Anonymous | TrustRadius Reviewer
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.

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

We have not found an analytical database faster than SingleStore. While our data volume per project is usually below 100 million rows, we expect reporting and analytics queries to be executed within 100ms so that dashboard users can interactively work with their data. So if you are looking for a truly fast analytical database, SingleStore is the right database to use (even though it is also crazy fast for OLTP workloads, but that is not our use case).

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.
We haven't seen a faster relation database. Period. Which is why we are super happy customers and will for sure renew our license.

Comments

More Reviews of SingleStore