I have a question about splitting data over multiple databases.
Can you tell me how feature like
setConnectionService works internally?
2 computers with 2 databases.
1 computer: MySQL, dbname = "Cat1", table = "Brands" (id, name,)
2 computer: PostgreSQL, dbname = "Cat2", table = "Cars" (id, user, brand), field "brand" contains id's from the 1st-computer's table "Brands".
According to the documentation I can set up framework enviroment for models "Brands" and "Cars"
php ($this->setConnectionService('MySQL') and $this->setConnectionService('PostgreSQL').
Do framework internally merge data from 2 computers (databases) when I pass such PHQL query:
php $phql = "SELECT Cars.name AS car_name, Brands.name AS brand_name FROM Cars JOIN Brands";