Re: PL/SQL vs Java in 10gR2 and up

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 16 Sep 2010 19:53:03 -0500
Message-ID: <AANLkTim8q7JpFoEq=yw102TNLJdTibP02pkSZiy09Hd7_at_mail.gmail.com>

Isn't there another line about doing it in C? I would expect that C would run faster than JVM...

On Thu, Sep 16, 2010 at 7:35 PM, Michael Dinh <mdinh_at_xifin.com> wrote:

> It depends.
>
>
>
> PL/SQL Vs. Oracle JVM: Speed Comparison for Mathematical Operations
>
>
>
>
> http://www.oracle-base.com/articles/misc/PlsqlVsOracleJvmSpeedComparisonForMathematicalOperations.php
>
>
>
> The tests now show the Oracle JVM is out-performing the PL/SQL for this
> basic looping and mathematical processing.
>
>
>
> These results are consistent for this test on database versions (9.2, 10.2,
> 11.1 and 11.2).
>
>
>
> Michael Dinh : XIFIN
>
>
>
> NOTICE OF CONFIDENTIALITY - This material is intended for the use of the
> individual or entity to which it is addressed, and may contain information
> that is privileged, confidential and exempt from disclosure under applicable
> laws. BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH
> INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING,
> AND AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI
> CONTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT
> NECESSARY TO PERFORM YOUR OBLIGATIONS RELATING TO THE RECEIPT OF THIS
> MESSAGE. If the reader of this email (and attachments) is not the intended
> recipient, you are hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited. Please notify the
> sender of the error and delete the e-mail you received. Thank you.
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Brady, Mark
> *Sent:* Thursday, September 16, 2010 2:43 PM
> *To:* 'oracle-l_at_freelists.org'
> *Subject:* PL/SQL vs Java in 10gR2 and up
>
>
>
> *This has been a Tom Kyte maxim for a few quite some time. I’m wondering
> if it still holds true between PL/SQL and Java.*
>
>
>
> 1. Do it in SQL.
>
> 2. If SQL can’t do it, do it in PL/SQL.
>
> 3. If PL/SQL can’t do it, do it in Java.
>
> 4. If Java can’t do it ask yourself if it needs to be done.
>
>
>
> *As versions progress often there are enhancements which correct
> deficiencies of the past. Have such enhancements occurred to put Java on a
> more equal footing? Is PL/SQL still the best method for scripting/stored
> procedure writing?*
>
>
>
> *In addition to a yes or no, could you add any specific advantages in
> terms of performance (vague, I know) that either one has over the other?*
>
>
>
>
>
> *Mark Brady*
>
> *Constellation Energy Group*
>
>
>
>
>
>
>
> >>> This e-mail and any attachments are confidential, may contain legal,
> professional or other privileged information, and are intended solely for
> the addressee. If you are not the intended recipient, do not use the
> information in this e-mail in any way, delete this e-mail and notify the
> sender. CEG-IP1
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 16 2010 - 19:53:03 CDT