MySQL Forums
Forum List  »  Newbie

How to manage year wise data in MySQL`!!
Posted by: FelixArthur FelixArthur
Date: May 17, 2020 11:00AM

I am developing a large application where I need to store all historical data year wise and per year millions of data will be stored Can anyone please suggest me an optimal strategy to achieve this, the main goal is performance should fast I thought can we backup every year data in a separate database? Is there other tricks or strategy to build the system more robust and effective?

Options: ReplyQuote


Subject
Written By
Posted
How to manage year wise data in MySQL`!!
May 17, 2020 11:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.