| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: A bit of fun
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jonathan Gennick
Sent: Tuesday, July 20, 2004 3:35 PM
To: Jared.Still_at_radisys.com
Cc: oracle-l_at_freelists.org
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@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> 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
----------------------------------------------------------------
 |
 |