Re: cross database joins performance hit?

2004-10-13 Thread Harald Fuchs
In article [EMAIL PROTECTED], Jason [EMAIL PROTECTED] writes: 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

Re: cross database joins performance hit?

2004-10-13 Thread Gary Richardson
I've worked on projects before where splitting up the schema into databases was used. Joins across DB's are fine, but there is another place that the performance can hit you. If you use something like perl's Apache::DBI, you will increase the number of open connections to your database. That's

cross database joins performance hit?

2004-10-12 Thread Jason
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