no no no. I see it -- it is Oracle Sales math. See that 1.9 and that 1.45? Well -- the ones match so just drop them. Then .45 is twice as fast as .9, so obviously your test confirms their results. Oracle Sales math has the interesting feature that any set of experimental results can be misused to support the desired claim. But I really thought the use of Oracle Sales math was currently in disfavor at Oracle. Seriously, though, I'm wondering what tests they ran before making such a claim. I'll try to remember to ask at our meeting in August. mwf -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jonathan Gennick Sent: Tuesday, July 20, 2004 3:35 PM To: Jared.Still@xxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: A bit of fun 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------