>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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).