KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm about to start a new project which should have a rather large database. The number of tables will not be large (<15), majority of data (99%) will be contained in one big table, which is almost insert/read only (no updates). The estimated amount of data in that one table is going to grow at 500.000 records a day , and we should keep at least 1 year of them to be able to do various reports. There needs to be (read-only) replicated database as a backup/failover, and maybe for offloading reports in peak time. I don't have first hand experience with that large databases, so I'm asking the ones that have which DB is the best choice in this situation. I know that Oracle is the safe bet, but am more interested if anyone have experience with Postgresql or Mysql with similar setup.
Tags (comma-separated)
Save Edits
Cancel