MySQL Forums
Forum List  »  Federated Storage Engine

Re: How to join two tables in different server?
Posted by: KimSeong Loh
Date: December 05, 2007 07:35PM

Thats my intention.

You get the local data, then send this to the remote server to complete the query with a separate connection. You can convert this easily with a subquery as compare to a join.

If you split data across different database server, I guess there is not much you can do.
If you use Federated table, it will probably send the data of the remote server to the local server for processing.

Options: ReplyQuote


Subject
Views
Written By
Posted
44074
December 04, 2007 01:55PM
Re: How to join two tables in different server?
16900
December 05, 2007 07:35PM
14274
April 14, 2008 10:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.