wsantos Posted August 20, 2007 Share Posted August 20, 2007 Precondition: Two databases on separate servers There is no way that this two databases be merged nor put on the same box ever. Question: I am to make a query that requires few data from one db and a few from the other one. How do I tackle this. Approach 1: I tried a query from one server and use the uniqueid as a parameter for a loop query on the other. Result: Performance Hit Web Browser Timeout Approach 2: I tried a Left outer join across server. Result: Cross server join is not impossible...as I was told Link to comment https://forums.phpfreaks.com/topic/65856-solved-subquery-across-servers/ Share on other sites More sharing options...
fenway Posted August 21, 2007 Share Posted August 21, 2007 If you make the login credentials the same, you might be able to connect to both; oh, but they're on separate servers... you can try FEDERATED tables. Link to comment https://forums.phpfreaks.com/topic/65856-solved-subquery-across-servers/#findComment-330450 Share on other sites More sharing options...
wsantos Posted August 23, 2007 Author Share Posted August 23, 2007 Sorry got tied up...I tried the federated table it worked when I need to get data from one server. But the problem came when I tried it with two separate server aside from my local machine. Thanks Link to comment https://forums.phpfreaks.com/topic/65856-solved-subquery-across-servers/#findComment-332277 Share on other sites More sharing options...
fenway Posted August 27, 2007 Share Posted August 27, 2007 Sorry got tied up...I tried the federated table it worked when I need to get data from one server. But the problem came when I tried it with two separate server aside from my local machine. Thanks Not sure what you mean, can't you just use two separate federated tables? Link to comment https://forums.phpfreaks.com/topic/65856-solved-subquery-across-servers/#findComment-335202 Share on other sites More sharing options...
wsantos Posted August 27, 2007 Author Share Posted August 27, 2007 That was what I did that did not work. I had a few typo errors that's why it didn't work. It's working now.Thanks. Link to comment https://forums.phpfreaks.com/topic/65856-solved-subquery-across-servers/#findComment-335216 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.