What users are saying about

1010data

5 Ratings

MemSQL

7 Ratings

1010data

5 Ratings
Score 4.2 out of 101

MemSQL

7 Ratings
Score 8.8 out of 101

Add comparison

Likelihood to Recommend

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.
Marc Gilbert profile photo

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.
Sachin Aggarwal profile photo

Pros

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
Marc Gilbert profile photo
  • 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 profile photo

Cons

  • The ten.do interface could use more detailed documentation
Marc Gilbert profile photo
  • 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
Sachin Aggarwal profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
MemSQL5.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 profile photo

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Henry PAN profile photo
No score
No answers yet
No answers on this topic

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
Marc Gilbert profile photo
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 profile photo

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
Marc Gilbert profile photo
  • 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.
Sachin Aggarwal profile photo

Pricing Details

1010data

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

MemSQL

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details