Xkeeper had that idea back in 2007: http://acmlm.kafuka.org/board/thread.php?id=1364&page=1

Basically, all post data would go in one table. Old post revisions would go in a separate table, and the main posts table would only hold the latest post revisions.


Supposedly, it'd be faster. Although MySQL is pretty fast already so there isn't much difference unless your board is big.


I gave it a try on my localhost, with two tests: one with the typical posts/poststext tables, one with a separate table containing the same data but all merged together in one table (and only latest post revisions). Each test ran a full post data fetch query on 20 random posts 10000 times.

The results are the following:

* separate posts/poststext: 7.3s
* merged table: 5.7s


There isn't much gain, but it isn't negligible either.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

This is being tested on Kuribo64. We'll see how it goes.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?