What is the best performance (or how best to do) in a MySql database, multiple tables, for example 'customer_business_01, customer_business_02' or a 'customer_business' table with customer ID?
Example:
I have a system where I can register a customer, and register purchases made by that customer. There is no product registration, only customer (name, cpf, email ...), and purchases (product, quantity, value ...).
My question is whether I create a 'purchases' table for each sample customer 'purchases_01' for the client with ID 01, or if I create a 'purchases' table and place a 'CUSTOM_ID' column.
Normally I would do the second way by creating a 'purchases' table with the 'CLIENT_ID' column, but the question arose whether the queries will be faster if I use a table for all purchases or a table of purchases per customer .
Ps .: You will not have many customers, but many purchases.