MySQL Forums
Forum List  »  Partitioning

Re: Help with partition strategy
Posted by: Nuno Donato
Date: January 28, 2020 10:12AM

My datatable receives thousands of news rows per day per user. So I'm afraid that in a few years it will become too big and make things slow.

I first thought about creating an "archive" table for rows older than X years, but partitions sound better as I dont need to fetch data from multiple tables if a user is fetching historic data.

Options: ReplyQuote


Subject
Views
Written By
Posted
1249
January 28, 2020 03:47AM
834
January 28, 2020 09:55AM
Re: Help with partition strategy
788
January 28, 2020 10:12AM


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.