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."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 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."
"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 features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
"Distribution concurrency control."
"IBM Netezza Performance Server is a cost-effective solution."
"The benefit is really because of the additional speed that we have and, truth be told, the more updated ETL processes and the revamped scheduler in general."
"The most valuable feature would be the fact that it has been running for awhile in an appliance format."
"The paramount advantage is the exceptional speed."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"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."
"Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server."
"Concurrency limit needs to be increased somewhat."
"The only issue is that it's not expandable."
"The scalability is not as expected. The capacity in the black box is not enough."
"Our main problem with it is concurrency. When there are too many users running Netezza at the same time, this is when we have the most complaints."
"LIke Teradata, we can’t add a node/SPU to the existing appliance."
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"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."
"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."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"We don't get good discounts in Pakistan."
"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."
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.