Re: Replication - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Replication
Date
Msg-id 20040421172803.GA325@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Replication  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Replication
List pgsql-general
On Wed, Apr 21, 2004 at 11:23:51AM -0400, Jan Wieck wrote:
> for that is NOT performance. SAP spends that effort multiple times by
> implementing their own, custom integrity control and data domain system
> in the DB abstraction layer, to gain DB vendor independence. That
> abstraction layer is larger than PHP and Apache together, so this
> example is IMHO totally irrelevant for the typical MySQL user.

Actually, I think it _is_ relevant.  It's proof, IMNSHO, that the
strategy of "doing it in the client" is completely bankrupt.  It's
one thing to do it this way if you have software which is a
category-killer the way SAP is, because you can afford the overhead
of all those developers doing all that extra work, and you can make
your customers buy trillion-dollar hardware to run your bloated
masterpiece.  The Rest Of Us, however, need to do things efficiently,
and that means doing the work in the place where it is least likely
to need to be checked again.  For most database applications, that's
inside the database.  (I'll not now start my rant on the mess caused
by developers who are careless with this principle.)

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
        --Roger Brinner

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: PL/SQL question
Next
From: Jan Wieck
Date:
Subject: Re: Mirroring tables from Oracle to Postgresql