SAP IQ vs. Trino

If you are loading massive datasets or aggregating huge relational datasets, SAP IQ is incredible. Loading 10 million rows in seconds is incredibly impressive.

Incentivized

• Superior performance in getting results for query
• Ability to scale up as data size/volume increase
• In memory solution and hence enhanced speed

Incentivized

• Installation, specifically licensing, is a pain.
• Connectivity is a bit tricky given that the SQL Anywhere drivers aren't native anywhere.

Incentivized

SAP IQ support is top-notch. I prefer starting all my SAP IQ support tickets with their Instant Messenger, where the majority of our issues are resolved. If it makes it to their ticketing system, they are very prompt at responding and very knowledgeable in the platform.

Incentivized

SAP IQ is perhaps an under-marketed product in the sense that it is able to scale up very well and perform much faster and more efficiently than other products such as Oracle - when we ran multiple large queries on both Sybase IQ and Oracle, we found that that results were much faster in Sybase IQ and this gave the confidence to go for this product.

Incentivized

• The ROI over a number of years has been good. Seeing as how we use it for billing, it has an obvious ROI to us.
• As they have been modifying their licensing structure, it's been difficult to keep up and understand how they work.

Incentivized