mardi 4 août 2015

MySQL - One table of each client or Single table with all clients

I am beginning a project where there will be multiple clients. In the database, each client can potentially have hundreds of thousands of rows.

Instead of having all of the clients in a single table, would it make sense to split the clients so that each has their own table? To me this makes sense since each time you query for a client, you would only be looking up a table with their data.

Aucun commentaire:

Enregistrer un commentaire