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@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 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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------


----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: