Learn how to manage tables that are growing in the database.

Assume a relational database using MySQL.

For example, how do you manage databases like bulletin boards that users post more and more, but cannot erase?

Even if I put an index on it, I'm worried that if it keeps getting bloated, it might get harder somewhere.

As a countermeasure that comes to mind, posts-2016 is a way to divide the tables year by year, but is there any standard?

mysql postgresql database-design

2022-09-29 22:23

2 Answers

Both MySQL and PostgreSQL have a feature called partitioning that handles tables that are divided under the conditions specified.

Please estimate the amount of data before considering whether you really need it.

2022-09-29 22:23

It may be different from the answer I am looking for, but I set up a separate server and operate it using SQL, Oracle, etc.There is also a limit to the server capacity, so I will consider deleting it somewhere.

2022-09-29 22:23

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656