Choosing MySQL or NoSQL Database For My Scenario
Date: Mon, 11 May 2015 21:53:54 -0700 (PDT)
Message-ID: <c23cfe35-4951-4111-96d0-aff04834a7e8_at_googlegroups.com>
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.
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
Received on Tue May 12 2015 - 06:53:54 CEST