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
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.
Sr. Analyst (Quality and MIS)
UnitedLex CorporationLegal Services, 501-1000 employees
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.

Verified User
Executive in Information Technology
Computer Software Company, 1001-5000 employeesPros
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.
Data Scientist & BioScience Project Manager
Fed Centric TechnologiesBiotechnology, 11-50 employees
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).
Senior Programmer/Analyst
Investment Company InstituteFinancial Services, 51-200 employees
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
Sr. Analyst (Quality and MIS)
UnitedLex CorporationLegal Services, 501-1000 employees
SAP IQ
- The pricing schedule is a bit expensive and cumbersome.
- Licensing for a virtual machine is difficult to understand.
Systems Administration Spec IV
XO CommunicationsTelecommunications, 10,001+ employees
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.
Data Scientist & BioScience Project Manager
Fed Centric TechnologiesBiotechnology, 11-50 employees
Support
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.
Senior Programmer/Analyst
Investment Company InstituteFinancial Services, 51-200 employees
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.
Sr. Analyst (Quality and MIS)
UnitedLex CorporationLegal Services, 501-1000 employees
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.

Verified User
Executive in Information Technology
Computer Software Company, 1001-5000 employeesReturn 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.
Data Scientist & BioScience Project Manager
Fed Centric TechnologiesBiotechnology, 11-50 employees
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.
Systems Administration Spec IV
XO CommunicationsTelecommunications, 10,001+ employees
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