pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Marten Feldtmann <marten@feki.toppoint.de>
To: chris@bitmead.com
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgreSQL.org <pgsql-hackers@postgreSQL.org>
Cc: pgsql-sql@postgreSQL.org
Cc: pgsql-general@postgreSQL.org
Subject: Re: [SQL] Re: [HACKERS] Proposed Changes to PostgreSQL
Date: Fri, 4 Feb 2000 19:15:31 +0100 (CET)
Message-ID: <200002041815.TAA07061@feki.toppoint.de> (raw)
In-Reply-To: <389A0932.6D4C0CC@nimrod.itg.telecom.com.au>

> Peter Eisentraut wrote:
> 
> 
> This is a really stu^H^H^H bad idea. I have hierarchies 5 levels deep
> with
> multiple inheritance, and I
> don't want to do a 10 way join just to retrieve an object.
> 
> This is why RDBMS's performance sucks so incredibly badly on some
> applications.
> an ODBMS can perform 100x as fast in these cases just because of what
> you
> are proposing.
> 

 Hmm, and yes one may find problems where the pure relational system
is 100x faster than your ODBMS.

 After doing a project with VERSANT and VisualWorks (election projection
system for the first television sender here in Germany) I like the
idea of OODBMS, but I've also noticed, that they are not the solution
to all problems.

 Clever database desing leeds to good performance on both systems, but
one should consider, that the designs of the database layout will be
different. There are cases, where a pure relational system is very
fast and an ODBMS never get it, but there are the examples you
mentioned.

 Joins per se are not that bad .. it depends on when and how they
are used and how good the analyzer of the database is and how good
he uses the indices to get the job done.

 One very good point is the query language of the rdbms systems. On
the odbms side no standard is really available, which can be seen as
the sql of the odbms.

 Marten





view thread (68+ messages)  latest in thread

Message-ID: <200002041815.TAA07061@feki.toppoint.de>
Permalink:  ../200002041815.TAA07061@feki.toppoint.de/
Also on:    postgresql.org/message-id/200002041815.TAA07061@feki.toppoint.de

 · 

reply

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-sql@postgresql.org
  Cc: marten@feki.toppoint.de, chris@bitmead.com, peter_e@gmx.net, pgsql-hackers@postgreSQL.org, pgsql-general@postgreSQL.org
  Subject: Re: [SQL] Re: [HACKERS] Proposed Changes to PostgreSQL
  In-Reply-To: <200002041815.TAA07061@feki.toppoint.de>
  References: <389A0932.6D4C0CC@nimrod.itg.telecom.com.au> <200002041815.TAA07061@feki.toppoint.de>

* 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