Re: A bit of fun

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 20 Jul 2004 15:35:16 -0400
Message-ID: <1117362768.20040720153516@gennick.com>

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@gennick.com

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_at_gennick.com and include the word "subscribe" in either the subject or body.

Tuesday, July 20, 2004, 12:41:21 PM, Jared.Still_at_radisys.com (Jared.Still_at_radisys.com) 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_at_freelists.org
JSrc> put 'unsubscribe' in the subject line.
JSrc> --
JSrc> Archives are at http://www.freelists.org/archives/oracle-l/

JSrc> FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Jul 20 2004 - 14:42:18 CDT