SAP IQ is a phenomenal relational big data database
November 20, 2019
SAP IQ is a phenomenal relational big data database
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with SAP IQ (formerly SAP Sybase IQ)
SAP IQ is currently our bid data database. We have several schemas with billions of rows, and both Oracle and Sybase were a bit slower than we liked. Moving our Data to SAP IQ showed a distinct increase in performance when doing bulk inserts and aggregates of data. We only began implementing SAP IQ about a year ago, and in the first six months, we tested it more than used it. For the past six months, we have been using it and are happy with the results.
- Inserting millions of rows of data takes seconds.
- Aggregating billions of rows of data is insanely fast (compared to Oracle, Sybase, and SQL Server).
- Installation, specifically licensing, is a pain.
- Connectivity is a bit tricky given that the SQL Anywhere drivers aren't native anywhere.
- Previous reports that took hours to run now execute in minutes, and sometimes seconds.
- Loads that were taking hours are now taking only a few minutes.
When dealing with row by row inserts, or developing front ends, all three databases above far exceed SAP IQ's performance. It struggles when trying to do individual small transactions.
When doing massive bulk transactions, or extensive queries, SAP IQ outperforms all three by factors greater than 10.
When doing massive bulk transactions, or extensive queries, SAP IQ outperforms all three by factors greater than 10.
Do you think SAP IQ delivers good value for the price?
Yes
Are you happy with SAP IQ's feature set?
Yes
Did SAP IQ live up to sales and marketing promises?
Yes
Did implementation of SAP IQ go as expected?
Yes
Would you buy SAP IQ again?
Yes