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."It supports multiple applications and business intelligence tools."
"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 solution's stability, performance, enhanced functionality, and replication are all great features."
"Replication is a valuable feature and easy to use."
"For IoT business cases, having Informix Enterprise Edition work on edge computers, like Raspberry Pi and using Informix replication, makes complex situations simple to build and maintain."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"IBM Informix benefits users with high availability and good integration capabilities."
"The scalability is very good."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"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'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."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The paramount advantage is the exceptional speed."
"The technical support services need substantial improvement."
"The solution lacks some functionality."
"I really would love to have a QT plugin."
"I would like to see backups from secondary servers."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"The pricing is a bit expensive."
"This product could be made easier to use for beginners."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
"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."
"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."
"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."
"We don't get good discounts in Pakistan."
"Having the ability to migrate servers using a single command would be extremely beneficial."
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, MySQL, Teradata, 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.