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.