We performed a comparison between IBM Informix and SingleStore based on real PeerSpot user reviews.
Find out what your peers are saying about SAP, Oracle, Firebird and others in Embedded Database."IBM Informix benefits users with high availability and good integration capabilities."
"The stability is incredible. I have customers with uptimes of several years."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"It supports multiple applications and business intelligence tools."
"It supports in-house-built applications in .NET and VB6"
"The scalability is very good."
"So far, we do not have a lot of issues. It's pretty problem-free."
"This solution has made financial reporting possible by allowing financial people the opportunity to set Informix to "Auto Pilot" so that they can attend other duties."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The paramount advantage is the exceptional speed."
"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
"This product could be made easier to use for beginners."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"I really would love to have a QT plugin."
"I would like to see backups from secondary servers."
"The technical support services need substantial improvement."
"The solution really doesn't add new features very often."
"In my opinion, the packages could be improved. The version I use doesn't allow for packages. I can do some general procedures, but no packages like in Oracle. So, develop separate modules in SQL language. This would be most beneficial for me."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"We don't get good discounts in Pakistan."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
IBM Informix is ranked 6th in Embedded Database with 16 reviews while SingleStore is ranked 6th in Database as a Service with 7 reviews. IBM Informix is rated 8.6, while SingleStore is rated 8.8. The top reviewer of IBM Informix writes "Quite stable and flexible but not very innovative". On the other hand, the top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". IBM Informix is most compared with Oracle Database, SQL Server, IBM Db2 Database, MySQL and MariaDB, whereas SingleStore is most compared with SQL Server, Teradata, MySQL, CockroachDB and Oracle Database.
We monitor all Embedded Database reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.