We're planning to use CiviCRM for a large number of voters (~10M voters).
This questions is related to the one here.
We were wondering if it's possible to split these 10M voters into different schemas. We want to keep one large database server instead of multiple smaller ones. We could divide the contacts based on geographies and store each of them in a separate site. Each site has its own schema. That way when we're filtering contacts on one site, it doesn't have to scan the entire contact database.
My question is - can we specify the scehma using a prefix? Or use some other configuration to point to a particular schema for an installation?