We performed a comparison between IBM Netezza Performance Server and SingleStore based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."The performance is most important to me, and it helps our ability to make business decisions quickly."
"IBM Netezza Performance Server is a cost-effective solution."
"The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
"We are able to execute very complex queries. Over 90 percent of our query executions are one second or less. We do millions of queries everyday."
"The data governance prospect... from what I've seen, that is a really powerful tool as well, to help with data lineage and keeping track of that."
"The most valuable feature would be the fact that it has been running for awhile in an appliance format."
"The underlying hardware that IBM provides with this appliance is made for a specific purpose, to serve performance on a large amount of data, and to do analytics as well. It is faster, when you compare it to any other product."
"Distribution concurrency control."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The paramount advantage is the exceptional speed."
"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."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"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."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"LIke Teradata, we can’t add a node/SPU to the existing appliance."
"Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server."
"We are not able to scale. The only way to scale is to get another appliance, but we have a customers who would need us to hydrate the data between the two appliances, and Netezza does not do that."
"In terms of features that I would like to see, one is the ability to actually scale out an architecture. Right now, if you buy one, it's fixed. There is no scale-up availability at all."
"The scalability is not as expected. The capacity in the black box is not enough."
"Concurrency limit needs to be increased somewhat."
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"The only issue is that it's not expandable."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"We don't get good discounts in Pakistan."
"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."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
More IBM Netezza Performance Server Pricing and Cost Advice →
IBM Netezza Performance Server is ranked 10th in Data Warehouse with 33 reviews while SingleStore is ranked 6th in Database as a Service with 7 reviews. IBM Netezza Performance Server is rated 8.0, while SingleStore is rated 8.8. The top reviewer of IBM Netezza Performance Server writes "A cost-effective data warehousing tool, but security features like TDE encryption are missing". On the other hand, the top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". IBM Netezza Performance Server is most compared with Oracle Exadata, Oracle Database, Snowflake and Teradata, whereas SingleStore is most compared with SQL Server, MySQL, Teradata, Oracle Database and CockroachDB.
We monitor all Data Warehouse 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.