Multiple tables or one table?

Question

I have already seen several forums with this question, but they do not answer the one thing I want to know. First I will explain my topic:

I have a system in which each log of several users is entered into the database (for example, User1 logged in, User2 logged in, User1 entered User management, User2 changed the password, etc.). Therefore, I would expect from 100 to 200 entries per user per day. Right now, I am doing this in one table and for viewing, I just need to filter using UserID.

My question is which is more efficient? Should I use one table or create a table for each user?

I am worried that if I use a single table, the system may have difficulty filtering thousands of records. I read some pros and cons using multiple tables and one table, especially regarding updating tables.

I also want to know which one saves more space? multiple tables or individual tables?

Answer 1

As long as you use indexes in the fields that you select, you should not have speed problems (although indexes slow down writing, so too much is bad). A table with several thousand records means nothing to mySQL (or any other database engine).

- , - .

, @, 150 000 , , , , .

, , , :

CREATE INDEX my_column_name ON my_table(my_column_name);

. ,

Answer 2

. userId .

, , , . , " "? " ?"

- , , , , .

Answer 3

1 . , . , , .

, , .

Answer 4

. , , , . , , . , , db .

Answer 5

, , , , . - , , .

, , . , . .

Answer 6

. , , , ( ). , , : http://www.liquibase.org/. .

I assume that if you use the right indexing, then a single table solution might work quite well (and maintenance will be much easier).