[OGDev] URGENT Re: [OpenGuides-Dev] OG performance

[David Cantrell]

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.

-- 
David Cantrell | Godless Liberal Elitist

    "There's a hole in my bucket, dear Liza, dear Liza."
    "WHAT MAKES YOU SAY THERE IS A HOLE IN YOUR BUCKET?"