V
V
Vadim Ivanenko2014-11-29 13:23:01
MySQL
Vadim Ivanenko, 2014-11-29 13:23:01

Function - Record archiving. How to organize the database structure?

There is an entity SomeEntity associated with others 1:1, 1:N. The application works with a list of SomeEntity objects. Some of these objects should be placed in a conditional "Archive" - ​​the same list.
You can add an archived field of type BOOL, but then the rows will accumulate in one table. Will it affect performance? Access to objects from the archive will be rare and there will be many of them.
How to organize it in a database?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question