Help with setting up a Database <p>My site is going to have many products available, but they'll be categorised into completely different sites (domains).</p> <p>My question is, am I better off lumping all products into one database and using an ID to distinguish between the sites, or should I set up a table and /or DB per site?</p> <p>Here are my thoughts</p> <p><strong>SEPARATE DATABASES</strong></p> <ul> <li>Easier to read from a backend</li> <li>Categorised better</li> <li>Makes backups more difficult</li> <li>If I need to make a change to the schema, it will need to be pushed out to all databases</li> </ul> <p><strong>SAME DATABASES</strong></p> <ul> <li>All in one place</li> <li>Could get unwieldy</li> <li>One database will have a massive file size and lookups could suffer</li> </ul> <p>Can someone please offer me some advice on which way is best and why?</p>