I would like to know if possible how a great e-commerce works for example, I would like to create my user and put my products for sale, in the example link:
www.loja.com.br/meunome www.loja.com.br/seunome
How does this work? Does the person create multiple databases or is it all done in one table? Let's assume you have thousands of hits per minute, how does it work?
It's actually simpler than it sounds. When you type loja.com.br/yourname, "yourname" is a unique record, as if it were an ID, but easier to record and divulge (than numbers). The developer uses a friendly URL to do this. Each product is then linked to each user. In the product table there may be a field called 'user_name', so when someone enters store.com / a_user, the system should only return the products related to them.
Regarding the accesses, it depends on the capacity of the server. Thousands of access per minute requires a good dedicated server.
