On Monday 02 Jun 2003 9:39 am, Nagib Abi Fadel wrote:
> From what i read dblink let's us access another database in the same query
> ... Which is great. But does it slow down the query ??
Don't use it myself, but from discussion on the lists, I'd say "probably" -
don't see how it could be otherwise. You'll want to test.
> And what about making references between tables (creating foreign keys) is
> it possible ?????
Nope - just not practical. You could bring both servers to a grinding halt
very quickly trying to keep track of FKs over a network link.
Incidentally, if you don't need the two databases on different machines,
perhaps look at using schemas to separate users - that would let you have FKs
etc.
--
Richard Huxton