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 7 out of 100

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 100

Based on 9 reviews and ratings

Likelihood to Recommend

MemSQL

The database speed and performance has been more than exceptional. Integrate MemSQL with zero help from their team, which is a credit to the ease of use of the product and quality of the documentation. It is blazing fast, especially with aggregation workloads, which is a hand in glove fit for us. Using it as row or column-based is just as good, but for in-memory aggregation. great for using in OLAP type environment

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 3 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

Anonymous | TrustRadius Reviewer
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

Sachin Aggarwal | TrustRadius Reviewer
Sachin Aggarwal
View all 3 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 | TrustRadius Reviewer
Zhann Goloborodko
View all 3 answers on this topic

Cons

MemSQL

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

Read full review

Tianwen Chu | TrustRadius Reviewer
Tianwen Chu
View all 3 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 | TrustRadius Reviewer
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 | TrustRadius Reviewer
Tianwen Chu
View all 1 answers on this topic

SAP IQ

No score
No answers yet
No answers on this topic

Support Rating

MemSQL

MemSQL 7.0
Based on 2 answers
MemSQL has developed a state of the art in-memory database management system with excellent support; unlimited database feature interface successful Has fast processing prioritize multiple operations for a successful product. It has excellent performance, and the MemSQL installation is straightforward. My experience in Implemented the solution was perfect. The database speed and performance has been more than exceptional.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 2 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 | TrustRadius Reviewer
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 | TrustRadius Reviewer
Sachin Aggarwal
View all 3 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

Anonymous | TrustRadius Reviewer
Verified User
View all 3 answers on this topic

Return on Investment

MemSQL

  • To scale on the fly. It required manual intervention.
  • Have to write core MySQL functions in-app layer, adding more complexity.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 3 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 | TrustRadius Reviewer
Eirik Toft
View all 3 answers on this topic

Screenshots

SAP IQ

—

Pricing Details

MemSQL

General

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

SAP IQ

General

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

Add comparison