[geeklog-devtalk] Sub-topics

[Graeme Merrall]

On Mon, 01 Nov 2004 06:58:32 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:

> I think most of us would agree (correct em if I'm wrong) that it is

> better to grab all the data in a single query and have PHP code sort the

> data out as opposed to making subsequent requests to the DB.  All the

> bigger Geeklog sites (Groklaw, macosxhints, etc) seem to experience DB

> load issues.  I've yet to get a legitimate complaint about the web

> server load (Dirk may have received such issues).


Agreed. I'm doing some stuff for macosxhints (hey Rob) and some of the
plugins make a number of IMHO unnecessary database calls.
With something like geeklog, or any other CMS, you always put your
fate in the hands of the developer or contributers to write the most
efficient code they can both in terms of the database or code.

As for database calls, it's *always* more efficient to do the
processing in PHP. The magic words with any database work is "round
trips". The less trips you can do to the database the better off you
are. This goes double when you have a separate database server.

Cheers,
 Graeme