From: | Marten Feldtmann <marten(at)feki(dot)toppoint(dot)de> |
---|---|
To: | chris(at)bitmead(dot)com |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>, pgsql-sql(at)postgreSQL(dot)org, pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [SQL] Re: [HACKERS] Proposed Changes to PostgreSQL |
Date: | 2000-02-04 18:15:31 |
Message-ID: | 200002041815.TAA07061@feki.toppoint.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-sql |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | James Maxwell | 2000-02-04 18:27:20 | Tough question from a potential user. |
Previous Message | kaiq | 2000-02-04 17:58:13 | Re: [GENERAL] using ID as a key |
From | Date | Subject | |
---|---|---|---|
Next Message | Douglas Ribas de Mattos | 2000-02-04 18:40:06 | Test |
Previous Message | Patrick Welche | 2000-02-04 17:11:53 | Re: [HACKERS] Another nasty cache problem |
From | Date | Subject | |
---|---|---|---|
Next Message | Taral | 2000-02-04 19:31:11 | Re: [SQL] Concurrency problem |
Previous Message | Tom Lane | 2000-02-04 15:43:59 | Re: [SQL] expensive query |