RE: PL/SQL vs Java in 10gR2 and up
- From: Michael Dinh <mdinh@xxxxxxxxx>
- To: "'Mark.Brady@xxxxxxxxxxxxxxxxx'" <Mark.Brady@xxxxxxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Sep 2010 17:35:28 -0700
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Brady, Mark
Sent: Thursday, September 16, 2010 2:43 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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
Other related posts:
