Cross database Views 3 backend

Categories

Component ID

618674

Component name

Cross database Views 3 backend

Component type

module

Component security advisory coverage

not-covered

Component created

Component changed

Component body

This module faciliates vertical sharding -- you can move tables to separate databases.

The main idea is to make Views build and execute a query which fetches IDs and then auxiliary queries fetching other fields from other databases. The fields involved in WHERE, ORDER, GROUP, HAVING should be in one database. The auxiliary queries on PHP 5.3 and MySQL will eventually use mysqli_poll to faciliate parallel processing.