Re: PostgreSQL with Phorum

From: "Brian Moon" <brian(at)phorum(dot)org>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>, <pgsql-general(at)postgresql(dot)org>, <pgsql-php(at)postgresql(dot)org>
Subject: Re: PostgreSQL with Phorum
Date: 2002-08-18 05:04:36
Message-ID: 014001c24674$bfced8b0$0100a8c0@doughboy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-php

| I don't have much time, but I'm happy to look at schemas and index
| optimisation for you, etc. Has Phorum removed its silly requirement of
| creating two whole entire tables per forum yet?

With Phorum 5 we have changed that. We had our reasons at the time for
doing that. However, things have changed and we are wiser and the tools are
better. This kind of gets back to my point. For small to moderately sized
Phorums on slower machines, having seperate tables is a good thing in MySQL.
We now know that large Phorums suffer in this case worse than the smaller
ones would suffer from one table. However, this could very well have never
been a good thing for PostgreSQL. I don't really know. At the time I
ported Phorum over to PostgreSQL, the docs were not nearly as good as they
are now. There was nothing about optimizing your tables for speed.

This is the reason I am coming here. I want Phorum 5 to run as fast as it
can on PostgreSQL.

Thanks,

Brian.
Phorum Dev Team

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brian Moon 2002-08-18 05:06:16 Re: PostgreSQL with Phorum
Previous Message Brian Moon 2002-08-18 05:00:14 Re: [GENERAL] PostgreSQL with Phorum

Browse pgsql-php by date

  From Date Subject
Next Message Brian Moon 2002-08-18 05:06:16 Re: PostgreSQL with Phorum
Previous Message Brian Moon 2002-08-18 05:00:14 Re: [GENERAL] PostgreSQL with Phorum