I'm redesigning my client's website in order to add about 16 mini sites for their web site. It's a website using PostgreSQL. And my question is:
Performance wise, what is the better database design:
- 1 (one) database, with about 190 tables, or
- 17 databases, one with 30 tables, and the rest with about 10 tables each.
It's for a low to middle traffic web site, but 4 or 5 times a year the traffic will be high.
It's a Centos 6 VPS, with 3 GB of RAM. Other softwares are Apache and PHP.