A bit of fun

From: <Jared.Still_at_radisys.com>
Date: Tue, 20 Jul 2004 09:41:21 -0700
Message-ID: <OF0EC721C1.4B080FD0-ON88256ED7.005AA91B-88256ED7.005BAC72@radisys.com>

While perusing a paper from OOW Australia: http://download-west.oracle.com/openworld/melbourne/all_melbourne_ppts/DB_B_09.PDF I noticed the claim that 10g PL/SQL is 2x faster than 9i PL/SQL. Further reading showed the native compilation helped bolster that claim, but
nonetheless it sounded like an interesting diversion before heading off to the Change Control Meeting.

Using my trusty prime generator, the following times were given for generating
all primes up < 100,000.

8i:      4.1 seconds
9i:      1.9 seconds

10g: 1.45 seconds

Though interpreted PL/SQL in 10g does not appear to be 2x faster than in 9i,
there is still a fair bit of improvement.

This is admittedly not a thorough test, but only takes a few minutes.

Code is at http://www.cybcon.com/~jkstill/prime6.html if interested.

Jared

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 - 11:38:07 CDT