novaBBS - comp.databases.theory - Re: Oracle is not a Server, not ACID/SQL Compliant, and it is a Performance Dog

Re: Oracle is not a Server, not ACID/SQL Compliant, and it is a Performance Dog

<184ae7a0-e6f4-4261-8629-5d6cb0461dd6n@googlegroups.com>

https://www.novabbs.com/devel/article-flat.php?id=81&group=comp.databases.theory#81

copy link Newsgroups: comp.databases.theory

X-Received: by 2002:a05:620a:52d:: with SMTP id h13mr25132913qkh.472.1619552811090;
Tue, 27 Apr 2021 12:46:51 -0700 (PDT)
X-Received: by 2002:aca:2316:: with SMTP id e22mr4607697oie.53.1619552810873;
Tue, 27 Apr 2021 12:46:50 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.theory
Date: Tue, 27 Apr 2021 12:46:50 -0700 (PDT)
In-Reply-To: <ad13e308-e8d8-4084-9fa7-706d7d243944n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=199.229.250.122; posting-account=bFMNewoAAAAHC6b_JPlV7XvI31zIuG5T
NNTP-Posting-Host: 199.229.250.122
References: <ad13e308-e8d8-4084-9fa7-706d7d243944n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <184ae7a0-e6f4-4261-8629-5d6cb0461dd6n@googlegroups.com>
Subject: Re: Oracle is not a Server, not ACID/SQL Compliant, and it is a
Performance Dog
From: derek.as...@gmail.com (Derek Ignatius Asirvadem)
Injection-Date: Tue, 27 Apr 2021 19:46:51 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 57

by: Derek Ignatius Asirv - Tue, 27 Apr 2021 19:46 UTC

Tony Andrews

After you have had your fill of sow's milk, a good sleep, and changed into a fresh nappy [diaper], perhaps you could look into the technical aspects of the thread.

> On Friday, 23 April 2021 at 10:20:31 UTC+10, Derek Ignatius Asirvadem wrote:
> > On Wednesday, 9 March 2016 at 22:07:58 UTC+11, Tony Andrews wrote:

====[ Oracle is a performance Dog ]===
1 Subquery COUNT ___________ 3.0 x slower than Sybase
3 InlineView COUNT __________ 3.6 x slower than Sybase
3 InlineView COUNT Improved 4.8 x slower than Sybase
1 Subquery SUM _____________ Abandoned after 120 mins (Sybase executed in 2..16 secs)
3 InlineView SUM ____________ 26.4 x slower than Sybase
3 InlineView SUM Improved __ 36.4 x slower than Sybase

You said //it doesn't matter that Oracle is slow with SUBQUERY() because everyone nappy user knows to code the requirement as an INLINE VIEW//, so we benchmarked both. Oopsey:
- Subquery never returned
--- perhaps the thousands of programs got tired of their never-ending chatter, and stopped talking to each other
--- same as PissGresNONsql
- InlineView is only 36 times slower.

Does the latest version of the famous self-cacking suite, of thousands of programs trying to do the same thing, do the thing it can't do, any faster ? My colleagues inform me that the latest version of the self-blocking RAC is even slower, and even better at cacking itself. They buy nappies in warehouse quantities, and enjoy warehouse prices.

Or perhaps you would like a benchmark between Oracle and PissGressNONsql. Prove that 3,000 commercial developers can produce a better result from their thousands of programs, than 10,000 academic coders spread across the planet. After all, the two of them have the same anti-philosophy, the same Stonebraker hysteria: deny the principle of a database and fabricate a subjective "reality".

Or perhaps you could deny the evidenced facts of reality, and challenge my declarations:

====[ Oracle is Not a Server ]===
====[ Oracle is Not ACID Compliant ]===
====[ Oracle is Not SQL Compliant ]===
No ?
Nothing ?
Ok, resort to attacking me personally, to form a distraction from reality. Buy nappies, because there will be consequences.

Cheers
Derek

Re: Oracle is not a Server, not ACID/SQL Compliant, and it is a Performance Dog

<7b62491c-24dc-4548-a31d-b818b9e52237n@googlegroups.com>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=83&group=comp.databases.theory#83

copy link Newsgroups: comp.databases.theory

X-Received: by 2002:ac8:6703:: with SMTP id e3mr27659868qtp.247.1619632593247;
Wed, 28 Apr 2021 10:56:33 -0700 (PDT)
X-Received: by 2002:a4a:3419:: with SMTP id b25mr7581044ooa.18.1619632592958;
Wed, 28 Apr 2021 10:56:32 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.theory
Date: Wed, 28 Apr 2021 10:56:32 -0700 (PDT)
In-Reply-To: <184ae7a0-e6f4-4261-8629-5d6cb0461dd6n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=85.115.52.201; posting-account=gSj7NQkAAABlAuBZQxQ3wuVlG7yuQVHa
NNTP-Posting-Host: 85.115.52.201
References: <ad13e308-e8d8-4084-9fa7-706d7d243944n@googlegroups.com> <184ae7a0-e6f4-4261-8629-5d6cb0461dd6n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <7b62491c-24dc-4548-a31d-b818b9e52237n@googlegroups.com>
Subject: Re: Oracle is not a Server, not ACID/SQL Compliant, and it is a
Performance Dog
From: tony.and...@gmail.com (Tony Andrews)
Injection-Date: Wed, 28 Apr 2021 17:56:33 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

by: Tony Andrews - Wed, 28 Apr 2021 17:56 UTC

On Tuesday, 27 April 2021 at 20:46:52 UTC+1, derek.a...@gmail.com wrote:
> (stuff)

I'm really sorry old bean, but I don't have the time or inclination to go over your benchmark exercise of 10 years ago. I'm sure you have proved to your satisfaction that SYBASE is X times faster than Oracle, and I will accept that too. I have no interest in dissing SYBASE or claiming Oracle is better.

Love and peace,

Tony

Re: Oracle is not a Server, not ACID/SQL Compliant, and it is a Performance Dog

<c1520f99-fcbf-4b87-945c-eefea0270d52n@googlegroups.com>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=84&group=comp.databases.theory#84

copy link Newsgroups: comp.databases.theory

X-Received: by 2002:a0c:dc08:: with SMTP id s8mr7806916qvk.12.1619691186865;
Thu, 29 Apr 2021 03:13:06 -0700 (PDT)
X-Received: by 2002:a9d:12e:: with SMTP id 43mr28147177otu.90.1619691186598;
Thu, 29 Apr 2021 03:13:06 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.theory
Date: Thu, 29 Apr 2021 03:13:06 -0700 (PDT)
In-Reply-To: <7b62491c-24dc-4548-a31d-b818b9e52237n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=199.229.250.150; posting-account=bFMNewoAAAAHC6b_JPlV7XvI31zIuG5T
NNTP-Posting-Host: 199.229.250.150
References: <ad13e308-e8d8-4084-9fa7-706d7d243944n@googlegroups.com>
<184ae7a0-e6f4-4261-8629-5d6cb0461dd6n@googlegroups.com> <7b62491c-24dc-4548-a31d-b818b9e52237n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <c1520f99-fcbf-4b87-945c-eefea0270d52n@googlegroups.com>
Subject: Re: Oracle is not a Server, not ACID/SQL Compliant, and it is a
Performance Dog
From: derek.as...@gmail.com (Derek Ignatius Asirvadem)
Injection-Date: Thu, 29 Apr 2021 10:13:06 +0000
Content-Type: text/plain; charset="UTF-8"

by: Derek Ignatius Asirv - Thu, 29 Apr 2021 10:13 UTC

Life's the same, except for the shoes. -- The Cars

devel / comp.databases.theory / Re: Oracle is not a Server, not ACID/SQL Compliant, and it is a Performance Dog

Subject	Author
Re: Oracle is not a Server, not ACID/SQL Compliant, and it is a	Derek Ignatius Asirvadem
Re: Oracle is not a Server, not ACID/SQL Compliant, and it is a	Tony Andrews
Re: Oracle is not a Server, not ACID/SQL Compliant, and it is a	Derek Ignatius Asirvadem