Hy, I have problems with Mysql query's made between few federated tables and local tables. With multiple joins in querys and inserts that are using one or two federated tables with two or three local tables results in time-out .... How can this problem be resolved?Where is the problem? Is not recomended? If not what is the best way to do it?
For example insert into a federated table of a query that is using one fed table right join with a local table and left joined with 2 local table and another join with fed table and a condition that is put on a fist local table and another condition put on a fed table. And first two table one local and second fed table are of 200.000+ items... thanks!