--- title: SingleStore Reviews meta_title: 'SingleStore Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 118 reviews by the users' company size, role or industry to find out how SingleStore works for a business like yours. aggregate_rating: rating_value: 4.5 review_count: 118 scale: '5' date_modified: '2026-07-07' parent_category: name: Database Software url: https://www.g2.com/categories/database-software --- # SingleStore Reviews **Vendor:** SingleStore **Category:** [Real-time Analytic Database Software](https://www.g2.com/categories/real-time-analytic-database) **Average Rating:** 4.5/5.0 **Total Reviews:** 118 ## About SingleStore SingleStore enables organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads — all in one unified platform. ## SingleStore Reviews ### 1. Cheat code for speeding up your database queries **Rating:** 4.5/5.0 stars **Reviewed by:** Marc W. | CEO, Small-Business (50 or fewer emp.) **Reviewed Date:** April 18, 2022 **What do you like best about SingleStore?** Two things: 1. The simplicity and speed of setting up a SingleStore environment. 2. The SQL performance increase you get straight off the bat. **What do you dislike about SingleStore?** It can be a little bit on the pricey side for large instances. **What problems is SingleStore solving and how is that benefiting you?** Typically we look at SingleStore when query performance on large datasets is bad on MySQL/Aurora. Moving to SingleStore is almost like a cheat code on some occasions! ### 2. SingleStore review **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** April 22, 2022 **What do you like best about SingleStore?** Best thing is you can choose the type of cloud provider you want to work with rather than being restricted to a specific one. Freedom to use any provider gives a lot more flexibility for application porting. **What do you dislike about SingleStore?** Just a User experience flaw Message appearing on top while the cluster was building up was confusing. Should have been more visible. **Recommendations to others considering SingleStore:** It is an easy solution to start soon. **What problems is SingleStore solving and how is that benefiting you?** Mainly to get away from Prem systems. I would add more options to import data from. Like, maybe from the HDFS system. ### 3. Good Cloud Database **Rating:** 4.5/5.0 stars **Reviewed by:** Vipen K. | Contractor, Small-Business (50 or fewer emp.) **Reviewed Date:** April 11, 2022 **What do you like best about SingleStore?** Pipeline creation and its execution. Unified UI for cluster/DB/Queries etc. **What do you dislike about SingleStore?** No dislike but wanted to explore and see query plans in a better format. Wanted to check monitoring. **What problems is SingleStore solving and how is that benefiting you?** Data pipelines (Not sure how & where transformations would be handled). Scalability, easy of use & responsiveness. ### 4. A great platform for all your database needs **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** May 10, 2022 **What do you like best about SingleStore?** The user experience is great. everything is 100% clear and well guided. **What do you dislike about SingleStore?** It was bit hard to find the SingleStore Studio link **What problems is SingleStore solving and how is that benefiting you?** great for the customers who are looking for cloud managed services that gives great user experience and amazing performance over data and are suitable for any domain (telco, banking, health etc..) including data analytics. ### 5. Fast performance and easy Integration **Rating:** 5.0/5.0 stars **Reviewed by:** Alex R. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 01, 2022 **What do you like best about SingleStore?** The speed and performance. We have loaded the huge datasets, the performance is tremendous. **What do you dislike about SingleStore?** None. Nothing to complain. Everything is good. **What problems is SingleStore solving and how is that benefiting you?** Data integration. Getting the records fast from various complex queries. ### 6. SingleStore is Super Seamless **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** April 20, 2022 **What do you like best about SingleStore?** I liked the layout of the tutorial. The plentiful examples helped understand the service. **What do you dislike about SingleStore?** I didn't like how some of the instructions were misleading. I wasn't sure if I was supposed to upload the mentioned excel file or not. **What problems is SingleStore solving and how is that benefiting you?** I needed a service that could handle scalability concerns and something that could be set up quickly. ### 7. System developer **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** April 11, 2022 **What do you like best about SingleStore?** Effortless to migrate local DB to the platform. **What do you dislike about SingleStore?** The current database in SQL Editor will be reset if the page has been reloaded. **Recommendations to others considering SingleStore:** It would be perfect if I can get a timely reply on my issue raised to portalhelp@singlestore.com. **What problems is SingleStore solving and how is that benefiting you?** Reduce the on-premises server required. The platform can reduce both hardware cost and maintenance cost. ### 8. Great Product **Rating:** 5.0/5.0 stars **Reviewed by:** Steven M. S. | Production Operation Team Lead, Small-Business (50 or fewer emp.) **Reviewed Date:** March 21, 2022 **What do you like best about SingleStore?** Effeciency and Speed of running process. **What do you dislike about SingleStore?** Inability of uploading local files from my pc **What problems is SingleStore solving and how is that benefiting you?** Efficiency and Optimisation of queries and big data ### 9. Amazing performance with MemSQL **Rating:** 5.0/5.0 stars **Reviewed by:** Mahesh K. | Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** August 12, 2020 **What do you like best about SingleStore?** MemSQL has an excellent processing power that helps in scaling and performing large data queries of IOT data. Deploying and configuring database clusters is really easy and clusters are deployed within a minute. MemSQL is capable of performing distributed parallel queries to execute thousands and millions of rows. **What do you dislike about SingleStore?** I have nothing specific to dislike about MemSQL and it has been an amazing experience utilizing MemSQL and it has shown great potential against other database solution in the organization **Recommendations to others considering SingleStore:** MemSQL processes large queries very easily and is a perfect solution for processing and working with large databases. I would really recommend other to give it a try and take a look on its documentation. **What problems is SingleStore solving and how is that benefiting you?** MemSQL simply solves the need of streaming analytics on big data and performing large data queries quickly and efficiently. It take cares of all the complex process and gets our work done quickly and saves our lot of time. It can easily pull up the data from multiple data sources and process them easily. ### 10. Fast and excellent datatbase solution **Rating:** 5.0/5.0 stars **Reviewed by:** mohd a. | Software Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** June 17, 2020 **What do you like best about SingleStore?** I would like to rate it at a full star. Having worked with almost all the databases, I can simply say it aces every database that I worked. Permissioning a new cluster by adding a super-user to MemSQL Ops and via GRANT statements on the cluster itself. Best practices for configuring memory limits. Best practices for basic cluster monitoring, and how to retrieve the relevant metrics. **What do you dislike about SingleStore?** I don't have any particular dislikes, but would love to see its own Client interface, inbuilt Data Modelling capabilities and a superb front end which can help potentially any Developers or Programmers to start the development from Day 1. Some administrative functions such as incremental, point-in-time, and object-specific backups and restore are lacking. The product is not fully mature. Although it uses the MySQL protocol, it does not always work with MySQL-compliant products. **Recommendations to others considering SingleStore:** 1. Amazing Performance. 2. ANSI and PL SQL compatibility. Enables easy transition from traditional databases to MemSQL. 3. Highly and easily Scalable 4. Easy to setup, easy to work with. **What problems is SingleStore solving and how is that benefiting you?** Backups can be written locally, then moved or copied via a scripted process to either a network location or object storage system. This approach avoids the potential performance impact of the previous option but requires adding an additional layer of complexity to the deployment and is asynchronous.Columnstore is a valuable feature. ### 11. Amazing performance in AdHoc queries and streaming analytics on the big databases **Rating:** 4.5/5.0 stars **Reviewed by:** navin s. | Software Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** June 09, 2020 **What do you like best about SingleStore?** I had a great experience with MemSQL that provides amazing performance in AdHoc queries and streaming analytics on the big databases. It is a robust software that easily aces every database and executing fast queries with real-time data ingestion. It is easy to setup and legacy compatible. The customer support was great and helpful to resolve technical issues. Overall I liked this software that has less learning path, easily supports MySQL, and compatible with other products as well. **What do you dislike about SingleStore?** Documentation has to be more informative and detailed with functionality. Overall I liked this software that has less learning path, easily supports MySQL, and compatible with other products as well. **What problems is SingleStore solving and how is that benefiting you?** It provides amazing performance in AdHoc queries and streaming analytics on the big databases. It is a robust software that easily aces every database and executing fast queries with real-time data ingestion. It is easy to setup and legacy compatible. The customer support was great and helpful to resolve technical issues. Overall I liked this software that has less learning path, easily supports MySQL, and compatible with other products as well. ### 12. Achieving Faster performance with MemSQL **Rating:** 5.0/5.0 stars **Reviewed by:** Saleem S. | Software Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** June 15, 2020 **What do you like best about SingleStore?** MemSQL efficiently handles large data and provides maximum performance. We can easily spin up new cloud database clusters and monitor the health of the database cluster. We can easily integrate and deploy MemSQL on different cloud service providers. It accepts AWS S3 as storage inputs and serves well as the data storage service. **What do you dislike about SingleStore?** MemSQL has helped us in having the fastest and powerful database that is capable of handling and processing large datasets. It is highly scalable and has almost fulfill our organization needs and we haven't had any issues with it. **What problems is SingleStore solving and how is that benefiting you?** MemSQL helps us in achieving super fast and accurate data responses in a matter of seconds. It let us store and process our large data on different clusters to achieve maximum performance and accuracy. MemSQL allows us to scale and provide maximum performance to our users. ### 13. Incredible fast performing Database **Rating:** 4.5/5.0 stars **Reviewed by:** Ashish C. | Software Developer, Enterprise (> 1000 emp.) **Reviewed Date:** June 10, 2020 **What do you like best about SingleStore?** MemSQL is the most powerful and fastest database for performing high-performance queries. The primary factor for utilizing MemSQL is speed and performance and capability to query over billions of rows. MemSQL is way more powerful and reliable than traditional databases in terms of speed, accuracy, and performance. We can have access to data in real-time and server crucial data to thousand of our users. **What do you dislike about SingleStore?** We never encountered any issues with MemSQL and it was a pretty awesome experience utilizing it. **What problems is SingleStore solving and how is that benefiting you?** MemSQL speed and accuracy are more than exceptional and it is our primary factor in choosing MemSQL. It's easier to achieve speed, performance, and scalability with MemSQL. Deploying and configuring MemSQL was an easy process and we were easily able to integrate it with our systems. ### 14. One of the best Database Solution **Rating:** 5.0/5.0 stars **Reviewed by:** Mayur G. | Enterprise (> 1000 emp.) **Reviewed Date:** June 13, 2020 **What do you like best about SingleStore?** MemSQL is the most perfect and reliable solution for streaming analytics and performing ad-hoc queries on large datasets. It can query millions of data in a matter of seconds and consuming fewer system resources. Queries and processes that usually took a lot of time are now processed very quickly and accurately without any issues. **What do you dislike about SingleStore?** MemSQL being a powerful and reliable database solution there is only one single problem that I have personally faced with backup and restoration process. **What problems is SingleStore solving and how is that benefiting you?** MemSQL has solved our issues of processing large datasets that took a lot of time and have helped us shift from old slow database to super fast and scalable database solution. We are able to run sophisticated and complex queries quickly and efficiently with MemSQL. ### 15. Most Powerful and fastest Database **Rating:** 5.0/5.0 stars **Reviewed by:** Hemant K. | Software Developer, Enterprise (> 1000 emp.) **Reviewed Date:** June 11, 2020 **What do you like best about SingleStore?** MemSQL helps in powering our complex applications by quickly analyzing and processing large datasets in the database. It can easily handle massive queries and provide quick processing and response. The process of storing and retrieval is pretty fast and it can easily process complex queries in seconds. **What do you dislike about SingleStore?** MemSQL utilizes huge physical resources of the instances in case of processing large datasets and it can be an issue if auto-scaling isn't configured. **What problems is SingleStore solving and how is that benefiting you?** We were able to perform and process large datasets and queries very quickly and efficiently. With the help of MemSQL, we were able to process millions of records in a second and deliver maximum performance. It has helped us process data quickly and efficiently than other databases. ### 16. Checked - One solution for Streaming Analytics on Big Data **Rating:** 5.0/5.0 stars **Reviewed by:** Sujay K. | Senior Manager, Data Engineering - Data & AI, Mid-Market (51-1000 emp.) **Reviewed Date:** December 26, 2019 **What do you like best about SingleStore?** - Super simple, we implemented the whole of our customer-facing streaming analytics data store in a 2-day hackathon - Natively integrates with AWS & other services (we are a multi-petabyte S3 shop with huge Kafka clusters) - Since most of it is SQL, anyone can hit the ground running in no-time, an ultra-low barrier to entry - We saw a sub-second response on a test case with 1000 concurrent heavy API calls (scanning billions of rows across many tables + window functions etc) along with applying RBAC functionalities on the fly - Incredibly fast out of the box, basic performance tuning will suffice 95% of use cases - Fantastic partners to work with, super helpful, we have access to their core engineering team, +100 on Customer engagement! **What do you dislike about SingleStore?** In my humble opinion, it solved a very unique hard problem for us elegantly (without having to compromise on any architectural or data principles). Problem of streaming analytics on high-velocity high volume data sets with sub-second API responses can be a handful. For me, this along with other use-cases they mention is their core strength. So anything beyond these capabilities is a "Nice to have" for me. Their roadmap covers most of what the community is asking - hot back-up's, better UI, modelling etc. **Recommendations to others considering SingleStore:** They offer a free trial, definitely try - you will not be disappointed with what you see. **What problems is SingleStore solving and how is that benefiting you?** Problem of streaming analytics on high-velocity, high volume data sets with sub-second API responses. This product elegantly solves the problem. ### 17. Faster performance with MemSQL Database **Rating:** 5.0/5.0 stars **Reviewed by:** SACHIN V. | IT Manager, Enterprise (> 1000 emp.) **Reviewed Date:** June 11, 2020 **What do you like best about SingleStore?** MemSQL is a highly reliable and scalable database service that is capable of processing the heavy workload of data. It guarantees deliverability of streaming data and provides detailed reports. It supports multiple database inputs such as MySQL, Postgres, SQL Server and many more. **What do you dislike about SingleStore?** Deployment process needs to be improved and their support isn't that quick and responsive in solving our technical issues. **What problems is SingleStore solving and how is that benefiting you?** MemSQL is a highly scalable relational database that simply helps us in performing large queries and processing large data across different clusters in the cloud. MemSQL has proven to be an efficient solution that quick scale and provides ultra-fast queries execution and performance. ### 18. My colleague in data analysis **Rating:** 4.5/5.0 stars **Reviewed by:** Rahul B. | Sr.Systems Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** May 15, 2020 **What do you like best about SingleStore?** MemSQL is a database that performs most of the operations in the frame compared to other commercial solutions, therefore it is also a much faster solution perfectly suited for data analysis compared to other databases. A great advantage of MemSQL is that the database is memsql compatible, making the transition very easy. **What do you dislike about SingleStore?** MemSQL is not suitable for smaller projects due to the need for a large amount of frame memory. **Recommendations to others considering SingleStore:** I will recommend using MemSQL to companies that want to improve the speed of data exchange and scale projects. **What problems is SingleStore solving and how is that benefiting you?** MemSQL gives me the ability to analyze data faster compared to the databases we used. ### 19. Incredibly fast performance for dashboards! **Rating:** 5.0/5.0 stars **Reviewed by:** Daniel F. | VP of IT Operations, Small-Business (50 or fewer emp.) **Reviewed Date:** October 08, 2019 **What do you like best about SingleStore?** We have had excellent luck with ingest rates and the ability to do lightning fast counts and other general math on time based data sets. If you are already familiar with SQL you will have little trouble utilizing this platform. Although we have had few occasions to use it, paid support was quite responsive and helped us correct issues quickly. Toolset allows for quick builds and deployments and services have been stable over significant periods of uptime. MemSQL Ops dashboard also allows for at-a-glace view to determine if your cluster is generally healthy. **What do you dislike about SingleStore?** Although I have heard of some people have positive results, I would like to implement autoscaling with the ability to increase licensing cost only for the time a cluster is scaled. I will soon be looking into MemSQL's Helios product to see if that is a reasonable path forward for us. **Recommendations to others considering SingleStore:** For our use case of doing math on time series data MemSQL has been a great success; if you are running basic SELECT statements and expect raw data in your results we didn't see as much of a speed increase but the ease of setting up a HA cluster is a definite bonus even then. **What problems is SingleStore solving and how is that benefiting you?** MemSQL provides the backend for our realtime dashboard and alerts system. MySQL compatibility makes it easy to import/export data to other databases when needed. ### 20. Fast and Furious **Rating:** 5.0/5.0 stars **Reviewed by:** Mohammad Sufiyan A. | Sr. DWBI/Data Architect, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** September 10, 2019 **What do you like best about SingleStore?** Having worked on the database for a quite a good time, I believe it is really going to be standing with its flag high. Its really fast, wonderful optimization, lots of flexibility and overall is very agile to git into the needs of small to large enterprises. **What do you dislike about SingleStore?** At present not many bloggers or its own forum which can really help the developers and architects for a quick resolution. Mostly relying on MYSQL posts to get the resolution. **Recommendations to others considering SingleStore:** I would suggest them, if they have the below problems then they should start engaging the MemSQL and go ahead with a POC and see by themselves rather than just relying on feed backs and comments. The range of issues could be: 1) Scalability 2) Real Time integration 3) Real Time Datawarehousing 4) Highly performing BI Platform. 5) Structured and unstructured data handling 7) SLA breaches in Webservices to name a few which could be the trigger points. **What problems is SingleStore solving and how is that benefiting you?** We are currently dealing with changing the existing solution of Wealth management on Sybase to MemSQL. Their primary problems is the scalability and the performance. We have realized both benefits at this stage and nearing to production implementation. ### 21. MemSQL - Faster Than Fast !! **Rating:** 4.5/5.0 stars **Reviewed by:** Sourabh V. | Data Architect, Enterprise (> 1000 emp.) **Reviewed Date:** September 12, 2019 **What do you like best about SingleStore?** I started using memsql last year and found that it is really quite easy to learn and work with MemSQL and unlike other databases you don't need extensive administrator activities to admin the memsql cluster and database per say. Apart from that when you start working with memsql, you can very well observe that the data storage and retrieval is quite fast and doesn't matter how many joins and complexities are involved in the queries, the query results are pretty fast. I also like the feature of memsql that the same DB system can be used for OLTP and OLAP purpose as well. **What do you dislike about SingleStore?** Many a times few things behave unique and different in memsql because of the settings of system variables which are set for the database, so user/developer needs to be aware of those variables. Example - Data truncation and data types conversion happen implicitly and provides different output depending on the system variables settings. **Recommendations to others considering SingleStore:** Not really at this time except that one needs to be pretty sure about the requirements that anyone have about what they are looking for because MemSQL provides both row store and column store engine and they both are for different purpose. **What problems is SingleStore solving and how is that benefiting you?** As an OLTP system which can be used for processing High transactions per second as the existing system was unable to handle the large amount of read and write transactions. All those writes were redirected to MemSQL for faster processing. ### 22. Scale and speed! **Rating:** 5.0/5.0 stars **Reviewed by:** Walt P. | Sr Manager Data Engineering, Enterprise (> 1000 emp.) **Reviewed Date:** September 11, 2019 **What do you like best about SingleStore?** I love how we can get scale and speed out of this database technology. We have loaded data in volumes that have historically stopped other database technologies in their tracks. We also have integrated the Memsql with our data visualization software which streamlines our reporting channels. **What do you dislike about SingleStore?** I don't have any complaints at this point. **Recommendations to others considering SingleStore:** Take the time to learn what is available specifically to MemSQL. The documentation available is incredibly helpful when making a determination about what we can do with MemSQL. It has been an invaluable piece of the puzzle for us when bringing junior developers online and up to speed about how things work with MemSQL. **What problems is SingleStore solving and how is that benefiting you?** Creating and maintaining secure databases at scale for our company. We have found that we don't need to ask if the database can handle the volume when using memsql. ### 23. Great performance and super easy to deploy **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Consumer Goods | Small-Business (50 or fewer emp.) **Reviewed Date:** September 10, 2019 **What do you like best about SingleStore?** By making use of the memsql-ops tooling, I'm able to quickly and easily spin up an entire cluster with HA. **What do you dislike about SingleStore?** The database makes heavy use of memory (which is one of its selling points), which can make it challenging in instances where large queries can bring a node to a halt due to out of memory issues. Improved understanding of the system and better monitoring can help work around that potential pit fall. **Recommendations to others considering SingleStore:** If you're able to accomodate the high-ish system requirements for a MemSQL cluster, and have the need for a high performance database for large datasets, give MemSQL a go. **What problems is SingleStore solving and how is that benefiting you?** Running queries over large data sets in reasonable amounts of time. We've been able to pump through many millions of records in seconds, where in other database systems we were having our queries time out. **Official Response from Rob Richardson:** > That’s phenomenal you’ve reached HA so quickly. What are the out-of-memory errors you encountered? How can we improve the documentation to make these easier to discover? Reach out to community@memsql.com. We’d love to learn more about your experiences. ### 24. Analyst **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** September 10, 2019 **What do you like best about SingleStore?** The UI of the product looks great but there is still scope for improvement. The Performance degrades at times. The buttons and features could be more interactive and re-prioritized for easiness of the customers working on it. **What do you dislike about SingleStore?** Structural backbone of the product looks unsustainable and might cause trouble in our use case. Latency on complex schema designs. We process huge chunk of data in TBs everyday and it is back and forth read write step that requires minimum latency, this product may not work as anticipated. **Recommendations to others considering SingleStore:** Performance for complex schema and UI. The buttons and features could be more interactive and re-prioritized for easiness of the customers working on it. The more a user works over the tool the more complexity and latency it observes. The site for resource declaration and deployment is another concern that can be dealt with and kept in mind while designing solutions to this platform. The occurrence of scenarios with customer based input/output latency is huge performance bottleneck. May be new version of the products are dealing with it in a mature and betterment data handling and storage. I love the product but still for all business needs it just doesn't add up **What problems is SingleStore solving and how is that benefiting you?** Customer identification system for various classification and predictive business needs. In order to read/write some scenario based variables, we need more scalability and less latency. The problem with TBs of data writing in MemSQL can be good but not at a large scale handling. We need more sustainability. **Official Response from Rob Richardson:** > It looks like you’re having difficulty scaling up your ingest pipeline. We’d love to help you refine the partitioning and indexes to reach the performance goals you’d expect. Can you reach out to community@memsql.com so we can help you with these queries? ### 25. Scaling Without Worries **Rating:** 3.5/5.0 stars **Reviewed by:** Garrett G. | Director of Product Management, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** September 13, 2019 **What do you like best about SingleStore?** The ease with which our team can build out new data models and deploy them into our production systems without worry that our infrastructure can handle it. **What do you dislike about SingleStore?** While MemSQL is an excellent managed database service, the price tag for the features that they deliver is fairly high compared to the market. **What problems is SingleStore solving and how is that benefiting you?** We are able to unify massive content delivery data across our clients in the Global 2000, and have built out a market leading analytics stack on top of that that we are able to deliver back to our clients. We have been able to rapidly develop and scale data models that have made us a leader in our space. ### 26. Memsql fast and stable! **Rating:** 4.5/5.0 stars **Reviewed by:** Yoni Y. | Database Administrator, Mid-Market (51-1000 emp.) **Reviewed Date:** September 11, 2019 **What do you like best about SingleStore?** Memsql works very fast it is easy to use and implement and it is mostly very stable and the support is mostly quick and responsive **What do you dislike about SingleStore?** There are some bugs sometimes but mostly they are fixable and you can continue without any impact . **Recommendations to others considering SingleStore:** I think i would highly recommend it for a businesses who have issues with data retrieval slowness and are looking to improve it's data retrieval speeds. **What problems is SingleStore solving and how is that benefiting you?** We solved a slowness in our grid reports by using memsql. This improved significantly the wait time our clients waited for reports to be generated and made their experience much more pleasant. ### 27. Simple to deploy and operate in modern micro service architecture **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** September 10, 2019 **What do you like best about SingleStore?** Simple to deploy, administer and operate with the highest performance to fulfill client requests. Fits well into the microservice and container-based application with the reliability you can count on. Capable to scale with the application demand. Easy to administer with the centralized tool and reactive web UI. **What do you dislike about SingleStore?** The backup and restoration can be a bit challenging. Simultaneous extraction of the back up can be a challenge with large scale deployment. lack of logging on deployment failures which are related to environmental factors. Requirements on internet access make it difficult to deploy in a closed network environment. **What problems is SingleStore solving and how is that benefiting you?** Increase in operation performance. ### 28. Easy to set up - super fast to use **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** September 11, 2019 **What do you like best about SingleStore?** The best thing about memsql is the speed at which queries are run - add kafka pipelines for your ETL process and everything data related becomes much easier. **What do you dislike about SingleStore?** Nothing really - everything runs pretty smooth and the support provided is great. **What problems is SingleStore solving and how is that benefiting you?** Our primary BI tool is Tableau - before we implemented MemSQL, we were connecting Tableau to MSSQL Server and running reports off there - however, the performance was extremely slow especially when querying large chunks of data. With Mem, we can query as much data as we need with little to no impact on performance time. **Official Response from Rob Richardson:** > I’m so glad you’ve found outstanding performance. Would you be willing to do a case study with us so we can highlight your achievements to the industry? Reach out to community@memsql.com. ### 29. MemSQL hungry for memory **Rating:** 0.0/5.0 stars **Reviewed by:** Verified User in Utilities | Mid-Market (51-1000 emp.) **Reviewed Date:** September 18, 2019 **What do you like best about SingleStore?** Few quires will run faster if you did everything correctly as per undocumented, unexplained MemSQL specification. **What do you dislike about SingleStore?** It's unusable as ANSI compliant SQL server. Single and simple insert, update and delete do not work. Data can be loaded faster if it is in perfectly formatted CSV file. It frequently runs out of memory. We have 3 nodes with 2 aggregates with total of 160GB of memory and it still runs out of memory. Local Pipelines can do very less in real world scenarios. **Recommendations to others considering SingleStore:** Evaluate other alternatives. **What problems is SingleStore solving and how is that benefiting you?** We were trying to manipulate large amount of electric meter reads and analyze our data with different scenario like area of server vs rate structures. So far it we have failed to materialize any advantage out of it. **Official Response from Rob Richardson:** > I'm glad you've discovered the speed of ingress pipelines, but it's unexpected that ansi sql queries wouldn't work as expected. What're the memory errors you're experiencing? Please reach out to community@memsql.com so we can better understand your concerns and help you achieve amazing results. ### 30. Good fit as an operational data store for legacy databases **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** September 13, 2019 **What do you like best about SingleStore?** Fast response times which makes it a good fit for an alternate ODS for legacy databases like Db2 on mainframe. Also, it has potential to be used for both for transaction processing as well analytical queries. **What do you dislike about SingleStore?** Some of the data types supported by legacy databases are not supported by MemSQL **Recommendations to others considering SingleStore:** A good option for ODS with legacy databases. Also, the in-memory processing means it can support both transaction processing as well as analytical queries. **What problems is SingleStore solving and how is that benefiting you?** On legacy databases like Db2 on mainframe, a bulk of the transactions are for read while a small part is related to write. Porting the data onto MemSQL and creating a copy allows the application to divert the inquiry calls to the alternate database thereby saving lot of money. **Official Response from Rob Richardson:** > It sounds like you’ve really become successful migrating your legacy workload reads to a more performant database. Would you be willing to do a case study with us so we can highlight your achievements to the industry? Reach out to community@memsql.com. ### 31. Amazing Performance of MemSQL **Rating:** 5.0/5.0 stars **Reviewed by:** Vasanth R. | Sr.Advisor, Enterprise (> 1000 emp.) **Reviewed Date:** September 11, 2019 **What do you like best about SingleStore?** Amazing performance of MemSQL both for reads and writes. No blocking sessions. Non blocking indexes. Excellent performance for Dashboards, mobile applications, warehouses, data science, realtime reporting performance. **What do you dislike about SingleStore?** Central monitoring not available. Indexes are built on start up and if there are too many indexes it takes more time. **Recommendations to others considering SingleStore:** High Speed normal SQL Database compared to other products in the market like Document / Key Store database which is difficult to understand. Apart from that, this also supports Document storage. **What problems is SingleStore solving and how is that benefiting you?** Data Science, OLAP Reporting using Tableau, BOBJ. ### 32. Perfect for our use case! **Rating:** 4.5/5.0 stars **Reviewed by:** Ben M. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** September 10, 2019 **What do you like best about SingleStore?** We, a Big 4 accounting firm, use MemSQL for rapid creation and destruction of clusters. MemSQL's speed and reliability are key for our use case since speed is our priority. **What do you dislike about SingleStore?** Getting used to using a shard key for our tables was a little slow for teammates to adopt. **What problems is SingleStore solving and how is that benefiting you?** Not having to keep clusters active saves time and money. MemSQL speed enables that competitive advantage. ### 33. Excellent In-memory Option for High-powered Data Analysis **Rating:** 4.5/5.0 stars **Reviewed by:** William R. | Technical Product Manager - diwo™ (Data In, Wisdom Out), Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** September 10, 2019 **What do you like best about SingleStore?** Ease of use, robust dependability and excellent support **What do you dislike about SingleStore?** Some timing issues with cache clearing, etc. But, resolved. **What problems is SingleStore solving and how is that benefiting you?** We handle extremely large data set analysis. MemSQL provides us with the capability to do so at incredible speed! ### 34. Simple & Speed Engine **Rating:** 4.5/5.0 stars **Reviewed by:** Chandra R. | Solutions Architect, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** September 12, 2019 **What do you like best about SingleStore?** I like it because it is a database manager very good compilations of data in structured language, it is easy to use is not cumbersome **What do you dislike about SingleStore?** Some timing issues with cache clearing, etc. But, resolved. **Recommendations to others considering SingleStore:** I recommend it is very good. Very scalable, fabulous, and very easy to use. I recommend it for the management of the data of the organizations. **What problems is SingleStore solving and how is that benefiting you?** Quickness of queries, use one query that contain all (without temp tables) ### 35. Recent MemSql Experience **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** September 10, 2019 **What do you like best about SingleStore?** The ease of installation and compatibility with all cloud providers is the best. Resilient components makes it easy for installing and maintaining as distributed components.DB replication feature is the best. **What do you dislike about SingleStore?** Instances are hard wired to memsql instance ids, It would be easier if we have option to add new one's and delete existing ones easily. The process of node joins and node decommission can made be simpler making all the cloud operations easy. **What problems is SingleStore solving and how is that benefiting you?** Found an alternate for realtime reporting that is currently using NOSQLDB. Currently, the NOSQLDB that is being used has real time data but it's not delete friendly and efficient. So memsql was our alternative option for reporting. ### 36. Used it for a personal project **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Education Management | Small-Business (50 or fewer emp.) **Reviewed Date:** September 12, 2019 **What do you like best about SingleStore?** MemSQL durability is slightly different for its in-memory rowstore and an on-disk columnstor which makes it awesome and a cluster can be configured in "High Availability" mode. It is also one of the fastest databases for columnar storage and analytical workloads. **What do you dislike about SingleStore?** A little maybe better documentation would be helpful , espically for beginners. Also to play around for smaller machines like raspbeery pi and some fun projects to start with. **What problems is SingleStore solving and how is that benefiting you?** I personally used it only on a personal level. It is insanely fast and very configurable. It also has a strong company and community behind it so that is pretty cool. ### 37. Work with Memsql everyday for our platform in Kenshoo **Rating:** 5.0/5.0 stars **Reviewed by:** Ofir B. | Software Development Team Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** September 17, 2019 **What do you like best about SingleStore?** The speed of queries, Kafka stream support, the easy to learn - syntax same as Mysql. Your support is great, answer quickly on ticket. **What do you dislike about SingleStore?** First query run time (compilation time), not easy and clear how to analyze/improve slow query. **What problems is SingleStore solving and how is that benefiting you?** Slow queries in Mysql. Memsql allow us to run all queries with no limitation on every scale of data. ### 38. Great product **Rating:** 4.0/5.0 stars **Reviewed by:** Omer B. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 10, 2019 **What do you like best about SingleStore?** The similarity to mysql. very clever architecture. very easy to use Kafka with im **What do you dislike about SingleStore?** The time that take for first query. The time that take to query with temp table (and in mySql is work very quick) **Recommendations to others considering SingleStore:** why using temp tables is doesn't work well in memsql **What problems is SingleStore solving and how is that benefiting you?** Quickness of queries, use one query that contain all (without temp tables) **Official Response from Rob Richardson:** > I’m so glad you’re enjoying the speed of ingesting Kafka data. Temp table performance is unexpected. Can you reach out to community@memsql.com so we can learn more about your scenario and help you achieve amazing results here too? ### 39. Great for extreme data processing **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** September 12, 2019 **What do you like best about SingleStore?** For extremely large data mining, memsql stands above the rest. The ability to process an extreme amount of data expediently is by far the greatest part of memsql. **What do you dislike about SingleStore?** Being on the Operations side of Memsql comes with it's challenges. There's a high learning curve for it, and at this time there isn't nearly as much out on the internet to help. Support is great, but being able to get in-the-moment answers is lacking. **What problems is SingleStore solving and how is that benefiting you?** Currently the teams are using Memsql to parse extremely large datasets in times that used to take days. ### 40. Integration - ease of use **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Consumer Services | Enterprise (> 1000 emp.) **Reviewed Date:** September 17, 2019 **What do you like best about SingleStore?** Well, our engineers were extremely happy to use MemSQL to integrate a no. of data we were trying to pull together. As i understand, this product made the ride jiffy! Keep doing the great work. **What do you dislike about SingleStore?** There was nothing specific that I can recollect we encountered while deploying memSQL. In case there was, I believe the support team was excellent. **Recommendations to others considering SingleStore:** N/A **What problems is SingleStore solving and how is that benefiting you?** Integrate a no. of data we were trying to pull together. As i understand, this product made the ride jiffy! Keep doing the great work. ### 41. Great technology **Rating:** 4.0/5.0 stars **Reviewed by:** Shiran Y. | Software Engineer, Internet, Mid-Market (51-1000 emp.) **Reviewed Date:** September 15, 2019 **What do you like best about SingleStore?** The queries are mostly the same as mysql so it's pretty easy to move to use memsql. The queries runs much faster and give our users a great experience using our system. **What do you dislike about SingleStore?** The first loading of the queries is a bit slow. **What problems is SingleStore solving and how is that benefiting you?** Queries performance ### 42. Nice UI, good integration with Spark **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Research | Enterprise (> 1000 emp.) **Reviewed Date:** September 11, 2019 **What do you like best about SingleStore?** Ease of use from Spark. Tables in hdfs was easy to put inside MemSQL from Spark (table is created from df schema). Connectivity plugin is added through spark-submit. Web UI allows writing commands, see memory usage, schema etc. **What do you dislike about SingleStore?** Upon uploading hdfs table into MemSQL due to insufficient memory node was going down. Wasn't able to delete this table due to some nodes being down. Auto table creating from Spark was missing columnstore save mode. **What problems is SingleStore solving and how is that benefiting you?** Updates on big tables (imported from Hadoop). ### 43. Dev Manager review **Rating:** 3.5/5.0 stars **Reviewed by:** Ido W. | Dev Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** September 11, 2019 **What do you like best about SingleStore?** Unique value proposition, provide performance and scalability of similar NoSql products, with a flexible SQL query support **What do you dislike about SingleStore?** Doesn't behave like traditional SQL DBs, lots of concepts and new behaviors to master, not so comprehensive analysis/monitoring tools available yet **What problems is SingleStore solving and how is that benefiting you?** High throughput of queries ### 44. MemSql a great tools for sub-second queries **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** September 12, 2019 **What do you like best about SingleStore?** The MemSql Studio is a great tool (profiling and resource usage are great features) The MySql compatibility is a great help for porting existing projects. **What do you dislike about SingleStore?** The FullText feature is limited in comparison to other tools (Analyzer flexibility), but I expect it to be improved. **Recommendations to others considering SingleStore:** It a very fast DB (using columnstore), easy to maintain and porting from MySql was flawless. **What problems is SingleStore solving and how is that benefiting you?** We are using it for an analysis dashboard that requires sub-second responses. ### 45. Evaluated memsql as poc for our use case **Rating:** 4.0/5.0 stars **Reviewed by:** Vidhya G. | Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** September 10, 2019 **What do you like best about SingleStore?** Good performance, scalability and easy setup. Kafka Integration was easy with native UI **What do you dislike about SingleStore?** Integration with BI tools (tableau, microstrategy) **What problems is SingleStore solving and how is that benefiting you?** Data lake with memsql. Performance increased multifold and scaled for large volume of data **Official Response from Rob Richardson:** > Great to hear you had a really smooth Kafka integration. How can we improve integration with Tableau and Microstrategy? Reach out to community@memsql.com so we can learn more about your use-case here. ### 46. Manage a huge data amount in ram **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** September 10, 2019 **What do you like best about SingleStore?** Store data across RAM's cluster and could access It really fast **What do you dislike about SingleStore?** Some strange behaviour like Primary Keys disorder in past upgrade. **What problems is SingleStore solving and how is that benefiting you?** Manage huge amount of data fast than others. ### 47. MemSQL is easy to use and performant **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Real Estate | Mid-Market (51-1000 emp.) **Reviewed Date:** September 12, 2019 **What do you like best about SingleStore?** Easy to perform maintenance of cluster and perform administrative tasks. Highly reliable and available even in default configuration. **What do you dislike about SingleStore?** Technical documentation is sometimes not great. I've needed to engage tech support frequently to bridge gaps and verify procedures. **What problems is SingleStore solving and how is that benefiting you?** We use MemSQL to perform complex geo-spatial queries against dynamically generated polygon areas which populates a search results window for real estate listings. ### 48. MemSQL looks promising and can definitely do a lot more **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** September 10, 2019 **What do you like best about SingleStore?** Obviously the processing capability. Though we are still in the initial stages, we are beginning to notice how efficient MemSQL is with its lightening quick speeds. **What do you dislike about SingleStore?** Lack of a good GUI. Having trouble with ODBC compatibilities, need to homogenize the drivers. **What problems is SingleStore solving and how is that benefiting you?** Part of an organizational initiative to replace legacy work horses with MemSQL. Again, efficiency is the key. ### 49. Excellent scalable distributed in memory database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** September 12, 2019 **What do you like best about SingleStore?** Very fast performance, excellent scalability, good support, good documentation and very stable product **What do you dislike about SingleStore?** No native admin tools means you have to use command line or MySQL workbench witch isn’t ideal **What problems is SingleStore solving and how is that benefiting you?** Coming from an MS SQL database it was much easier to develop a multi fault tolerant database that outperformed a rotational disk array states many fold. **Official Response from Rob Richardson:** > Excellent performance is wonderful. Have you tried using MemSQL Studio, the web-based SQL Editor and monitoring tool? ### 50. Feedback on MemSQL **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** August 27, 2019 **What do you like best about SingleStore?** The Columnar store on the disk and the performance it gives on commodity hardware. **What do you dislike about SingleStore?** HA can be enabled only for the entire configuration, it would have been great if we could enable HA just for the memory components or just at disk level. **What problems is SingleStore solving and how is that benefiting you?** In- Memory speed persistance stance layer for memory based application pipelines ## SingleStore Discussions - [Is there provisin forthe software to be open source or will this be only following a Pay for Services model?](https://www.g2.com/discussions/is-there-provisin-forthe-software-to-be-open-source-or-will-this-be-only-following-a-pay-for-services-model) - 1 comment, 1 upvote - [How the complex and internal architecture is different from native MySQL](https://www.g2.com/discussions/how-the-complex-and-internal-architecture-is-different-from-native-mysql) - 1 comment, 1 upvote - [When does it hang running memsql-ops --start sometimes](https://www.g2.com/discussions/when-does-it-hang-running-memsql-ops-start-sometimes) - 1 comment, 1 upvote - [Can we Use Amazon Kinesis to ingest data into memsql](https://www.g2.com/discussions/can-we-use-amazon-kinesis-to-ingest-data-into-memsql) - 1 comment, 1 upvote - [How to simplify scaling of MemSQL cluster?](https://www.g2.com/discussions/16032-how-to-simplify-scaling-of-memsql-cluster) - 1 comment, 1 upvote - [View SingleStore pricing details and edition comparison](https://www.g2.com/products/singlestore/reviews?page=2§ion=pricing&secure%5Bexpires_at%5D=2026-07-09+15%3A07%3A36+-0500&secure%5Bsession_id%5D=658868d2-0b78-470b-92f7-5067c0ef3af9&secure%5Btoken%5D=2db20a6c07e76b69574baa235930b93b9bafa09bd2a394a12f8667c0f491f24b&format=llm_user) ## SingleStore Features **Management ** - Data Schema - Query Language - ACID - Complaint - Data Replication **Data Indexing** - Semantic Search - Indexing Data **Query latency** - Lower query latency - Continuous queries **Support ** - Text Search - Data Types - Languages - Operating Systems **Data latency** - Lower data latency - Data pipeline performance **Security** - Database Locking - Access Control - Encryption - Authentication **Filters** - Accurate Search - Single Stage Filtering - Vector Database **Connectors** - Faster ingestion - Built-in connectors **Performance ** - Disaster Recovery - Data Concurrency - Workload Management - Advanced Indexing - Query Optimizer **Scale** - Linearly scalable database - Storage management **Architecture** - Data security - Lockless architecture **Database Features** - Storage - Availability - Stability - Scalability - Security - Data Manipulation - Query Language ## Top SingleStore Alternatives - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) - 4.4/5.0 (649 reviews) - [CockroachDB](https://www.g2.com/products/cockroachdb/reviews) - 4.3/5.0 (27 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,580 reviews)