I currently have a website that uses a MySQL database to store Site content with multiple queries per pages to multiple tables (over 200 but not all on 1 page call)
I have 3 basic areasof the site:
1) the main site content (displayed on every page)
2) some advertising tables (every page) (specifically PHPadsnew)
3) a chat module (not on every page)
I'm just wondering if technically it makes since to subdivide these out into 2 - 3 databases. Will I see any performance problems either way?