X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0B162D1B482 for ; Wed, 21 Apr 2004 14:28:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 53774-01 for ; Wed, 21 Apr 2004 14:28:46 -0300 (ADT) Received: from web02-imail.rogers.com (web02-imail.bloor.is.net.cable.rogers.com [66.185.86.76]) by svr1.postgresql.org (Postfix) with ESMTP id A0D73D1BACC for ; Wed, 21 Apr 2004 14:28:44 -0300 (ADT) Received: from phlogiston.dydns.org ([65.49.125.184]) by web02-imail.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040421172722.WUU249420.web02-imail.rogers.com@phlogiston.dydns.org> for ; Wed, 21 Apr 2004 13:27:22 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 605903C28; Wed, 21 Apr 2004 13:28:03 -0400 (EDT) Date: Wed, 21 Apr 2004 13:28:03 -0400 From: Andrew Sullivan To: pgsql-general@postgresql.org Subject: Re: Replication Message-ID: <20040421172803.GA325@phlogiston.dyndns.org> Mail-Followup-To: pgsql-general@postgresql.org References: <20040420115108.GC29715@phlogiston.dyndns.org> <40869207.8020509@Yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <40869207.8020509@Yahoo.com> User-Agent: Mutt/1.5.5.1+cvs20040105i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at web02-imail.rogers.com from [65.49.125.184] using ID at Wed, 21 Apr 2004 13:27:22 -0400 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200404/753 X-Sequence-Number: 59995 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