Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle For Fun

Re: Oracle For Fun

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 01 Feb 2004 16:38:46 -0800
Message-ID: <1075682270.753428@yasure>


Daniel Morgan wrote:
> Jeff wrote:
>
> Over the weekend I'm going to put all of the solutions into a benchmark
> and then publish the results.
>
> But be forwarned ... The Regular Expressions solution, at least with 10g
> Beta 2, is not going to win any awards for speed. Where's that Beta 15 I
> requested Mark? ;-)

As promised I have performed the testing:

The contestants and results can be found at: http://www.psoug.org/sql_fun.html

One lesson comes through very clearly from the results ... test, test, test. Don't be too quick to think you know what's best just by looking at the code you've written.

And never was that more obvious than with this example.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sun Feb 01 2004 - 18:38:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US