Lyceum

Lyceum 是一套多人修改自 WordPress 的軟體，以提供多人使用。Matt 在 WordPress and Lyceum 這篇提到關於 Lyceum 對於資料庫的設計：

From my examination of the code, it seems it’s exactly what WordPress MU is except they’ve modified every SQL statement (what a pain!) to use a monolithic table structure. We tested this approach for MU, but found it was too expensive to scale past a certain point. With monolithic structures you hit a wall based on your hardware.

In MU users are divided and can be partitioned easily, for example on WordPress.com we have the users partitioned between 4096 databases, which allows you to scale very cheaply and efficiently to hundreds of thousands and even millions of users and extremely high levels of traffic.

結果 WordPress.com 對於 Database 的作法都一樣… (默)