Choosing MySQL or NoSQL Database For My Scenario

See more:

MongoDB

NoSQL

Hello All,

I have a scenario where i have to store timesheets of different projects. The object graph is like this:
Timesheet->Project->User

A user can create multiple projects. And a project can have multiple timesheets. So in my scenario it is expected that timesheet data will grow continuously. So if I create a table for timesheet in MySQL the data in it will start growing continuously which can become a bottleneck. I have to read timesheets also i have to edit them and create new ones quite often.

So can you please guide which database is best for this scenario MySQL or NoSQL database(MongoDb and Cassandra). If NoSQL is best please tell me which would be best MongoDb or Cassandra. I have review both of them quite in detail but cannot decide which one to use.

I also have a requirement to index tables by multiple fields.

I have read about mongodb and cassandra both are good at insertion, but cassandra is good at updating data.

Please suggest me good solution.

Thanks,
Bilal