X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 25B6B11F663F for ; Wed, 12 Apr 2006 12:03:31 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.6 X-Spam-Level: X-Spam-Status: No, score=-2.6 required=5 tests=[BAYES_00=-2.599, SPF_PASS=-0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id 0FD-9p4I00ov for ; Wed, 12 Apr 2006 12:03:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.233]) by postgresql.org (Postfix) with ESMTP id 4CE7B11F68DF for ; Wed, 12 Apr 2006 12:03:26 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 67so1180457wri for ; Wed, 12 Apr 2006 08:03:26 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Qxq/zzjepkNTSXVOPXOkt2GEuNRR3hiZCW5X/4qVMogOK9BBMJTUlSrPyFVxTPPoWWNlsOIaNHE7J5siGTDur9oKpQifZYxX//xZPU0EDzuq6zQJgJxkUhFlZXlvF77OEwU6mnS4xlYadX/bPqih19Sxjw9RxAJIZMnM6D9iBXI= Received: by 10.65.250.8 with SMTP id c8mr1117753qbs; Wed, 12 Apr 2006 08:03:26 -0700 (PDT) Received: by 10.65.137.8 with HTTP; Wed, 12 Apr 2006 08:03:26 -0700 (PDT) Message-ID: Date: Wed, 12 Apr 2006 11:03:26 -0400 From: "Merlin Moncure" To: "Rodrigo Sakai" Subject: Re: FOREIGN KEYS vs PERFORMANCE Cc: pgsql-performance@postgresql.org In-Reply-To: <001301c65d9c$08884ef0$4700a8c0@TREEZANTHUS> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <001301c65d9c$08884ef0$4700a8c0@TREEZANTHUS> X-Archive-Number: 200604/264 X-Sequence-Number: 18348 On 4/11/06, Rodrigo Sakai wrote: > > Hi, > > I think this is an old question, but I want to know if it really is wel= l > worth to not create some foreign keys an deal with the referential integr= ity > at application-level????? > Specifically, the system we are developing is a server/cliente > architecture that the server is the database and the fat client is an > application developed in DELPHI!!! > > Thanks in advance!! Delphi IMO is the best RAD win32 IDE ever invented (especially when paired the very excellent Zeos connection objects). However, for purposes of data management ,imperative languages, Delphi included, simply suck. Great form editor though. merlin