From: Brian Moon <brian@phorum.org>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: pgsql-general@postgresql.org
To: pgsql-php@postgresql.org
Subject: Re: PostgreSQL with Phorum
Date: Sun, 18 Aug 2002 00:04:36 -0500
Message-ID: <014001c24674$bfced8b0$0100a8c0@doughboy> (raw)
References: <00d001c24665$85dc3e40$0100a8c0@doughboy>
<008101c2466d$e5a28c50$0200a8c0@SOL>
| 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: brian@phorum.org, chriskl@familyhealth.com.au, pgsql-general@postgresql.org
Subject: Re: PostgreSQL with Phorum
In-Reply-To: <014001c24674$bfced8b0$0100a8c0@doughboy>
References: <00d001c24665$85dc3e40$0100a8c0@doughboy> <008101c2466d$e5a28c50$0200a8c0@SOL> <014001c24674$bfced8b0$0100a8c0@doughboy>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox