is it better to have a database for each user who is introducing data in the website or have a table for each user in the same database (in terms of speed for searching)?
I'm asking that because in my server they allow me to have 100 databases and I have ten different users who will introduce data in the website. So I can create ten tables in one database or use a database for each user. In which situation will be faster the communication?
Thank you very much in advance,