Path: ...!local-2.nntp.ord.giganews.com!Xl.tags.giganews.com!local-4.nntp.ord.giganews.com!nntp.earthlink.com!news.earthlink.com.POSTED!not-for-mail
NNTP-Posting-Date: Mon, 28 Oct 2024 04:58:34 +0000
Subject: Re: The joy of Ada
Newsgroups: comp.os.linux.misc
References: <pan$96411$d204da43$cc34bb91$1fe98651@linux.rocks>
 <20241021075543.00000494@gmail.com> <vf6f0q$13ctc$2@dont-email.me>
 <20241021151652.00005675@gmail.com> <vf6n47$14l9a$3@dont-email.me>
 <lno9vqF368kU2@mid.individual.net> <vf6u3q$15nlq$3@dont-email.me>
 <20241022095931.00001d38@gmail.com> <vf93a5$1l20u$6@dont-email.me>
 <20241022144815.00007ea5@gmail.com> <vf98l2$1lsqn$3@dont-email.me>
 <20241022153631.00002ec9@gmail.com> <vfamtn$21039$1@dont-email.me>
 <vfbo4u$28v56$5@dont-email.me> <vfcft1$2ftu7$1@dont-email.me>
 <vfcgcv$2g0g1$3@dont-email.me>
 <nv2dnXjQd4-8foT6nZ2dnZfqn_sAAAAA@earthlink.com>
 <vfcptl$2hjp4$1@dont-email.me>
 <CCadnQ4B-oXSboT6nZ2dnZfqnPidnZ2d@earthlink.com>
 <vfebuf$2pkdl$4@dont-email.me>
 <Os6dnedZ6uqxbof6nZ2dnZfqn_WdnZ2d@earthlink.com>
 <nCQSO.297925$EEm7.62385@fx16.iad> <lo2as5Fj476U1@mid.individual.net>
 <qn_SO.297938$EEm7.187626@fx16.iad> <vfif3b$3m055$4@dont-email.me>
 <y7aTO.203218$WtV9.22893@fx10.iad> <vfl257$bic6$4@dont-email.me>
 <vfmbct$jekn$9@dont-email.me>
From: "186282@ud0s4.net" <186283@ud0s4.net>
Organization: wokiesux
Date: Mon, 28 Oct 2024 00:58:34 -0400
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.13.0
MIME-Version: 1.0
In-Reply-To: <vfmbct$jekn$9@dont-email.me>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Message-ID: <VjKdnS8_KJVnhIL6nZ2dnZfqnPSdnZ2d@earthlink.com>
Lines: 29
X-Usenet-Provider: http://www.giganews.com
NNTP-Posting-Host: 99.101.150.97
X-Trace: sv3-6HUCQxdtDhlZiqsiynGVmT72RcSSAzdQ+h2mBWXKi4fM2kXuNnwF7yplMzCPLdB7mQp2ZAQ79HkWG/d!G5tvzABBWZJ6Pb570GETL3/EcWEnshhFd0UewicYqZM7RMtE8ipyyZv5jTJy4h+6GKpwvXpA04T7!3NMNTYp2ShqnajJv0BZV
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
Bytes: 3530

On 10/27/24 5:30 PM, Lawrence D'Oliveiro wrote:
> On Sun, 27 Oct 2024 09:46:15 +0000, The Natural Philosopher wrote:
> 
>> I never bothered learning the more arcane side of SQL because if I ever
>> managed to get the query right, it was always so abysmally slow that it
>> was quicker to use a series of simple queries and join them together in
>> application code rather than SQL
> 
> I have found quite the opposite. Remember that, the more information you
> put in the query up front, the more clues you give to the query optimizer.

   Long back I did extensive development on a PICK-OS based DB
   called 'Revelation'. It DID do an early version of SQL. It
   was used for over a decade.

   HOWEVER you never used the SQL beyond the top-level selections
   because it was too slow. Thereafter you used the "advanced"
   functions - hidden in the back of the manuals - to access the
   indexes and sorting routines and such - because they were ten
   or even 100 times quicker.

   Oh, they still sell 'Revelation' - DOS based - for about
   $300 ... but no support. Nice really, integrated WYSIWYG
   text-screen form builder too.

   Yes you CAN build a sophisticated query using SQL - but
   the syntax is TERRIBLE, hyper-prone to error, oft just
   un-readable - and the speed is still bad. Intelligently
   join yer OWN damned sets with proper code.