Dear community, I have a question about high-load development with Phalcon.
Phalcon PHP provides instruments to set the correct sources for the Model's data-tabels. But, internally, Phalcon does not work with "JOIN" when the tables for the SQL-query located on different database-servers ( http://forum.phalconphp.com/discussion/398/splitting-data-over-multiple-databases ). So, to resolve "miltiple databases JOIN" problem, I need to use (for example) 2 queries for 2 tables and then join queries results with php-code. It works nice and fast.
But there is nice thing called "MySQL Cluster", and it can accept 1 big-join-query and collect data from multiple database nodes. http://www.clusterdb.com/mysql-cluster/70x-faster-joins-with-aql-in-mysql-cluster-7-2/
Which method is scalable and preferable?