On Thu, Jul 26, 2007 at 01:24:50AM +0100, Rev Simon Rumble wrote:
I think a rudimentary publishing mode would be helpful. The front page doesn't need to be built from the database every time, so having it published might be good. I suspect putting the latest changes on there causes a fair bit of pain.
That's certainly something that could be done just every few minutes, or whenever there's an edit. In fact, the same idea could be applied to every page - *all* user requests would get served static HTML, and those static pages would be regenerated automatically whenever the data behind them is changed. So that way, only searches and edits hit the database. On a normal wiki, those are a very small proportion of total requests.
A good halfway house might be to use something like Squid to proxy all incoming requests and to cache very common pages, such as the home page, and serve them from the cache instead of hitting the OG code at all. I'd be happy to help with configgering this.