From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-0.9 required=5.0 tests=BAYES_00,FORGED_GMAIL_RCVD,
	FREEMAIL_FROM autolearn=no autolearn_force=no version=3.4.4
Path: 
 eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: =?UTF-8?Q?Bj=c3=b6rn_Lundin?= <b.f.lundin@gmail.com>
Newsgroups: comp.lang.ada
Subject: Re: Prepared_Statement :(
Date: Tue, 27 Nov 2018 20:02:14 +0100
Organization: A noiseless patient Spider
Message-ID: <ptk4bl$i3c$1@dont-email.me>
References: <ce530325-6c40-458f-bd51-b5f03eebe02e@googlegroups.com>
 <37a5643e-02aa-48ab-b327-f76771d1f6e6@googlegroups.com>
 <ptk0nt$1n1r$1@gioia.aioe.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Injection-Date: Tue, 27 Nov 2018 19:02:13 -0000 (UTC)
Injection-Info: reader01.eternal-september.org;
 posting-host="785b4610d8e9b5ae88150bdd9b006d57";
	logging-data="18540"; mail-complaints-to="abuse@eternal-september.org";
	posting-account="U2FsdGVkX18WcfvvA9KOnsI3u7FBlWEz"
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.8.0
Cancel-Lock: sha1:H3M1SAbPzb5qWGcETqP8VCH+MtI=
In-Reply-To: <ptk0nt$1n1r$1@gioia.aioe.org>
Content-Language: en-US
Xref: reader01.eternal-september.org comp.lang.ada:54915
Date: 2018-11-27T20:02:14+01:00
List-Id: <comp.lang.ada>

On 2018-11-27 19:00, Dmitry A. Kazakov wrote:
> I cannot tell if PostgreSQL is better than Oracle or MySQL or whatever.
> One should really benchmark them for the specific case to know.
> 
> What I know is that the difference cannot be any dramatic. 

Oh yes it can.
Perhaps not for inserts, but for selects. (hm actually for inserts as
well, in old mysqls using table locks. Scales bad with many writers)

Especially if you are not alone, ie, there are other
writers when you read.
The RDBM's internal strategy for looking can be a show stopper on one DB
and great on another.

>If one of
> them stops working all others probably will, and conversely. So if you
> have a real DB problem you possibly must say goodbye to all relational
> SQL-based DBs and look for a better custom algorithmic solution.

Possibly, but not likely. Unless your problem was not suited for an RDBM
from the beginning


-- 
--
Björn