What users are saying about

MemSQL vs SAP IQ

MemSQL
7 Ratings
SAP IQ
9 Ratings

MemSQL

7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.1 out of 101

Based on 7 reviews and ratings

SAP IQ

9 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

Based on 9 reviews and ratings

Likelihood to Recommend

MemSQL

MemSQL is especially useful to serve as a back-end storage for spark streaming, and also small update problems. The streamliner technology is very helpful to process daily streaming data and consequent data analysis. Same SQL syntax is also very handy for people to learn and use.

Read full review

Sachin Aggarwal profile photo
Sachin Aggarwal
View all 2 answers on this topic

SAP IQ

Does data compression very well, produces query results very quickly, ability to scale up as data volume/size grow in an organization, row level versioning is in memory and hence the speed. It is a very stable product for large enterprises. More detailed documentation on how to use this product in the initial stages would be really welcome.

Read full review

No photo available
Verified User
View all 3 answers on this topic

Pros

MemSQL

  • Faster query speed than traditional SQL database.
  • It con server in the pipeline to deal with streaming data with Kafka, spark streaming and MemSQL
  • It is very scalable.

Read full review

Tianwen Chu profile photo
Tianwen Chu
View all 2 answers on this topic

SAP IQ

  • Inserting millions of rows of data takes seconds.
  • Aggregating billions of rows of data is insanely fast (compared to Oracle, Sybase, and SQL Server).

Read full review

Zhann Goloborodko profile photo
Zhann Goloborodko
View all 3 answers on this topic

Cons

MemSQL

  • Provide faster python API for invoking MemSQL
  • MemSQL connection between spark failed when more than around 48 partitions data processing
  • Better tuning of MemSQL performance on Scale-up server

Read full review

Sachin Aggarwal profile photo
Sachin Aggarwal
View all 2 answers on this topic

SAP IQ

  • The pricing schedule is a bit expensive and cumbersome.
  • Licensing for a virtual machine is difficult to understand.

Read full review

Eirik Toft profile photo
Eirik Toft
View all 3 answers on this topic

Likelihood to Renew

MemSQL

MemSQL 5.0
Based on 1 answer
I still want to see the performance about using latest version of spark and memsql. About renewal, if there is a new and better version of spark-memsql connector, then maybe.

Read full review

Tianwen Chu profile photo
Tianwen Chu
View all 1 answers on this topic

SAP IQ

No score
No answers yet
No answers on this topic

Support

MemSQL

No score
No answers yet
No answers on this topic

SAP IQ

SAP IQ 10.0
Based on 1 answer
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.

Read full review

Zhann Goloborodko profile photo
Zhann Goloborodko
View all 1 answers on this topic

Alternatives Considered

MemSQL

I have tried using CSV as a back-end storage, yet I/O is very heavy, direct transit from spark to MemSQL in memory really beats.

Read full review

Sachin Aggarwal profile photo
Sachin Aggarwal
View all 2 answers on this topic

SAP IQ

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.

Read full review

No photo available
Verified User
View all 3 answers on this topic

Return on Investment

MemSQL

  • It offers me solution to solve spark storage problem
  • It adds more complexity of my application since multiple tech softwares are involved.
  • More types of bugs will be encountered when doing streamliner, including hardware connection.

Read full review

Tianwen Chu profile photo
Tianwen Chu
View all 2 answers on this topic

SAP IQ

  • 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.

Read full review

Eirik Toft profile photo
Eirik Toft
View all 3 answers on this topic

Pricing Details

MemSQL

General

Free Trial
—
Free/Freemium Version
—
Premium Consulting/Integration Services
—
Entry-level set up fee?
No

SAP IQ

General

Free Trial
—
Free/Freemium Version
—
Premium Consulting/Integration Services
—
Entry-level set up fee?
No

Add comparison