A
A
Alexander2017-06-21 23:08:12
MySQL
Alexander, 2017-06-21 23:08:12

Many records in one database table or several tables?

We make a widget for websites. It is necessary to store information about all visitors of all connected sites. In the future, there will be millions of records.
MySQL DB.
Which of the options is better in terms of performance:
1. Store everything in one table
2. Make a separate table for each site
?
Perhaps there are links where you can read more about this. Thanks in advance for your advice.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
Vitaly Stolyarov, 2017-06-21
@alexperec

1. Store everything in one table
Proof

S
Sergey, 2017-07-31
@begemot_sun

In the future, there will be billions of records :)
If you use cookies and some ID for authorization, then the worst case for you is when the user does not support cookies at all, thus. each request is a unique user.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question