Subject | Re: [ib-support] Cross-db query |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2002-10-22T10:38:14Z |
Hi Antonio!
choice is to import one of the tables into the other database (if you
really need this on a more permanent basis, I guess one-way replication
could be worth looking into). What Interbase do support is transactions
that span several databases, but each query etc. can only be on one
database (exception: the BDE is capable of doing this, but it is a real
performance killer not recommended to try on tables with more than a few
records).
Set
>Is Interbase supporting cross-db query?. If not, how I can join two tablesNo, you simply cannot do this. If you need to join them, I guess your best
>resides in two different databases?
choice is to import one of the tables into the other database (if you
really need this on a more permanent basis, I guess one-way replication
could be worth looking into). What Interbase do support is transactions
that span several databases, but each query etc. can only be on one
database (exception: the BDE is capable of doing this, but it is a real
performance killer not recommended to try on tables with more than a few
records).
Set