Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question