Cheap and best db that people can use
October 05, 2016

Cheap and best db that people can use

Ajay Akunuri | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with MySQL

This is used by my team for a dashboard that we created. Our whole organization was using Oracle and db2, but we started using this to create our own dashboard which will be shared with all the teams for monitoring purposes. This is very cheap and we didn't have to spend much on this and it's very easy to install and easy for us to troubleshoot issues.
  • It's very easy to install and use. Once installed, we didn't have any issues and never had to reach out to our IT teams for support. The UI was very easy to use even for the first timer.
  • We have some complex queries for the data in our dashboard and it used to take a lot of time. The dashboard had a lag in showing the data. After migrating to MySQL, data was loading much faster on the UI because of MySQL.
  • There was an issue when using the MySQL UI and as most of the team is used to SQL developer, they pressed control and enter and it executed all the update statements that are there on that page instead of executing just that query, which is very annoying.
  • This is a great deal for our project as it's less expensive when compared to other databases and it has almost all the functionalities that we need for our project.
  • This also improved our situation where there is a lag in getting the output on dashboards.
  • Oracle
The main reason that we went with MySQL is the cost. It's very cost effective and can do almost everything that Oracle can do. Database management is also very simple when compared to Oracle as we didn't have to contact the DBA for issues. Also, we found a lot of improvement in the query performance when compared to Oracle.
This is very useful when we need it for a small project and it's easy to use and manage. This is cheap as well. There are not many options in data manipulations as compared to Oracle. If it is for a big organization, I feel Oracle is better.