The Worst Thing in the World ...and it feels just like I'm walking on broken glass

that's a really interesting hack to split the db.

i don't think your method would help us since we have enough nodes in each domain (so many user profiles, so many forum posts) that even splitting into multiple sites would lead to overload.