Re: A bit of fun
- From: Jonathan Gennick <jonathan@xxxxxxxxxxx>
- To: Jared.Still@xxxxxxxxxxx
- Date: Tue, 20 Jul 2004 15:35:16 -0400
Hello Jared,
I believe you must double your input voltage in order to get
that 2x improvement in PL/SQL execution time. Do you have a
240-volt outlet handy?
(Just kidding Jared! Please don't try that at home!)
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article,
or send email to Oracle-article-request@xxxxxxxxxxx and
include the word "subscribe" in either the subject or body.
Tuesday, July 20, 2004, 12:41:21 PM, Jared.Still@xxxxxxxxxxx
(Jared.Still@xxxxxxxxxxx) wrote:
JSrc> While perusing a paper from OOW Australia:
JSrc>
http://download-west.oracle.com/openworld/melbourne/all_melbourne_ppts/DB_B_09.PDF
JSrc> I noticed the claim that 10g PL/SQL is 2x faster than 9i PL/SQL.
JSrc> Further reading showed the native compilation helped bolster that claim,
JSrc> but
JSrc> nonetheless it sounded like an interesting diversion before heading off
JSrc> to the Change Control Meeting.
JSrc> Using my trusty prime generator, the following times were given for
JSrc> generating
JSrc> all primes up < 100,000.
JSrc> 8i: 4.1 seconds
JSrc> 9i: 1.9 seconds
JSrc> 10g: 1.45 seconds
JSrc> Though interpreted PL/SQL in 10g does not appear to be 2x faster than in
JSrc> 9i,
JSrc> there is still a fair bit of improvement.
JSrc> This is admittedly not a thorough test, but only takes a few minutes.
JSrc> Code is at http://www.cybcon.com/~jkstill/prime6.html if interested.
JSrc> Jared
JSrc> ----------------------------------------------------------------
JSrc> Please see the official ORACLE-L FAQ: http://www.orafaq.com
JSrc> ----------------------------------------------------------------
JSrc> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
JSrc> put 'unsubscribe' in the subject line.
JSrc> --
JSrc> Archives are at //www.freelists.org/archives/oracle-l/
JSrc> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
JSrc> -----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
