Easy to store relational data.
March 19, 2018

Easy to store relational data.

Nikita kumari | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with MySQL

We store customer query data into a MySQL database, as we keep the record of every user into our database so it is easy to check the status of their queries.
  • Easy to add joins on tables.
  • Easy to keep records of every user.
  • Protection from an unauthorised user as we have to provide a valid username and password while logging into SQL DB.
  • It should create indexes automatically if a table has a large amount of data.
  • It should add a feature so that we can restrict access to a particular table from a database.
  • Need improvement in query performance.
  • Increased the productivity of business.
  • Easy to handle client queries.
  • Storing customers credentials into DB.
As MongoDB does not support relational queries we have to write all queries manually, but My Sql supports this feature through joins.
If we have complex or dependency data we always prefer to use MySQL as it provides an RDBMS feature. If we have a larger amount of data it does not give a better performance.