RE: RE: pl/sql is INTERPRETED?

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Tue, 30 Apr 2002 02:13:28 -0800
Message-ID: <F001.00452E4E.20020430021328@fatcity.com>

('binary' encoding is not supported, stored as-is)
>Saw some basic demo's at a BMC/Simulus seminar
>revealed that compiled units were certainly faster
>than their interpreted counterparts - I can't
>remember
>off hand but it was in the order of 20-30% maybe?
>Of
>course, typically the main performance problems
>with
>PL/SQL are:
>
>a) poor SQL within the code
>b) inefficient (ie row at a time) handling of the
>results

 c) Confucean respect for specs (eg SELECT COUNT(*) to test for existence)
 d) Confucean respect for specs (eg reprogramming nested loops)
 e) Confusion (if you thought I was going to start with the same word you're wrong :-)) between 'relational table' and 'sequential file'
 f) Love for complexity
 g) ...

>neither of which I believe native compilation will
>help with greatly.
>

I second that !

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Apr 30 2002 - 05:13:28 CDT