What users are saying about
7 Ratings
9 Ratings
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
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

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

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

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.
Sachin Aggarwal | TrustRadius Reviewer

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).
Zhann Goloborodko | TrustRadius Reviewer

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
Tianwen Chu | TrustRadius Reviewer

SAP IQ

  • The pricing schedule is a bit expensive and cumbersome.
  • Licensing for a virtual machine is difficult to understand.
Eirik Toft | TrustRadius Reviewer

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.
Tianwen Chu | TrustRadius Reviewer

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

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.
Zhann Goloborodko | TrustRadius Reviewer

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.
Sachin Aggarwal | TrustRadius Reviewer

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

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

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.
Eirik Toft | TrustRadius Reviewer

Screenshots

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