For high-performance large-scale databases, I should think that a heirarchical architecture would be indicated. Here’s one way to do it:

Put tables on dedicated back-end servers. Have a front-end cluster do the logic, joins, etc.

Lots of variations are fairly obvious.

Anyhow, I just thought I’d write it down while I was flushing the old explosive logorrhea queue.