I've tried to find references to if there are any design flaws with using multiple databases or not however was unable to locate anything (but I was told by a previous co-worker that there were performance hits).
Are there any performance hits or design flaws by separating a large database into separate databases then cross-database joining the tables? (these tables have anywhere between 1m and 5m+ rows) Thanks for any pointers in advance. If theres a major design flaw to splitting a database up into separate databases I'd like to know before getting to far down the path on this project :-) Thanks much for any answers!
