MySQL Forums
Forum List  »  Federated Storage Engine

Federation perfomance much slower
Posted by: Hans Won
Date: October 02, 2012 09:30AM

We are finding performance of a federation query to be 4-5 times slower than running the query directly on the server. we have 2 instances running on the same server, where one is federating off the other. if you run select * from table a (fairly large table > 200K rows) on the federated server then it runs 5x slower than running it directly on the source server. why?

Options: ReplyQuote

Written By
Federation perfomance much slower
October 02, 2012 09:30AM
November 07, 2012 10:15AM

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.