Re: Oracle Closed World
From: TheBoss <TheBoss_at_invalid.nl>
Date: 24 Jun 2012 22:37:03 GMT
Message-ID: <4fe7968f$0$6876$e4fe514c_at_news2.news.xs4all.nl>
"Gerard H. Pille" <ghp_at_skynet.be> wrote in news:4fe766ee$0$3104$ba620e4c_at_news.skynet.be:
>> On 24.06.2012 19:41, Gerard H. Pille wrote:
>>> Robert Klemme wrote:
>>>>
>>>> It's not the worst thing to motivate developers to move from
>>>> procedural code to SQL... :-)
>>>> Procedural is often used because it is easier to understand for
>>>> humans. But unfortunately you
>>>> can bring any database's performance down with the wrong set of
>>>> procedures and triggers.
>>>
>>> Not with SQL?
>>
>> No, never!! ;-)
>>
>> My badly worded point was that a procedural solution often cannot be
>> optimized the same way a single query can - for example because the
>> query then is spread across a number of different queries. Or data is
>> aggregated in a temp table and then processed further which creates
>> more IO etc.
>>
Date: 24 Jun 2012 22:37:03 GMT
Message-ID: <4fe7968f$0$6876$e4fe514c_at_news2.news.xs4all.nl>
"Gerard H. Pille" <ghp_at_skynet.be> wrote in news:4fe766ee$0$3104$ba620e4c_at_news.skynet.be:
> Robert Klemme wrote:
>> On 24.06.2012 19:41, Gerard H. Pille wrote:
>>> Robert Klemme wrote:
>>>>
>>>> It's not the worst thing to motivate developers to move from
>>>> procedural code to SQL... :-)
>>>> Procedural is often used because it is easier to understand for
>>>> humans. But unfortunately you
>>>> can bring any database's performance down with the wrong set of
>>>> procedures and triggers.
>>>
>>> Not with SQL?
>>
>> No, never!! ;-)
>>
>> My badly worded point was that a procedural solution often cannot be
>> optimized the same way a single query can - for example because the
>> query then is spread across a number of different queries. Or data is
>> aggregated in a temp table and then processed further which creates
>> more IO etc.
>>
> > I know, Robert, I know, just kidding. I know people who'd call two > functions to retrieve two columns from the same record. >
I wonder what dbms they use.
As relational ones do have columns but no records (they have rows), and
hierarchical (like IMS) do have records but no columns (they have fields),
they probably use a hybrid, hierarcho-relational dbms, with HSQL (or DL/2?)
as the language to manage the data stored in segment tables...
-- JeroenReceived on Sun Jun 24 2012 - 17:37:03 CDT