Best approach for creating databases for sub-sites I have to create a website that has about 1000(in future thousands) sub-sites. How should I create database for this sub-sites? Creating a separate database per site, or creating for example 10 databases, each one for 100 sites(using table prefixes), or ...?
The option to use table prefixes exists because some hosting providers limit the number of databases. Don't use this feature unless your hosting provider is one of those.