Re: Suggestions for alternate UPDATE command syntax

From: Hugo Kornelis <hugo_at_pe_NO_rFact.in_SPAM_fo>
Date: Mon, 04 Apr 2005 09:27:31 +0200
Message-ID: <feq151ds7m9ebkjevqvhaubmn6p20fn11h_at_4ax.com>

On 3 Apr 2005 16:38:44 -0700, Neo wrote:

(snip)

>// Create a challenge and its solutions for different hardware.
>(CREATE challenge inst *"common ancestor report"
>  & it solution (CREATE solution inst *"x#1a"


>                  & it author neo


>                  & it hardware (CREATE hardware inst *"dell server"


>                                  & it cpu (CREATE cpu inst *"P II"
>                                             & it speed +"500 Mhz"))


>                  & it database (CREATE database inst *xdb1


>                                  & it version +4.5.9)


>                  & it "execution time" +"1.63 ms"


>                  & it "download location"


>                             +"www.xdb1.com/Example/Ex076.asp")
(snip)

Hi Neo,

Whaddya mean: "& it version +4.5.9)" ?? That version was made after you

posted the challenge! Version 4.4.7 was the current version when you set the challenge.

Let's correct this part, and hange it to reflect comparable hardware (I hope I get the syntax right - boy, is this counterintuitive!)

// Create a challenge and its solutions for different hardware. (CREATE challenge inst *"common ancestor report"   & it solution (CREATE solution inst *"x#1a"

                  & it author neo
                  & it hardware (CREATE hardware inst *"desk top"
                                  & it cpu (CREATE cpu inst *"P III"
                                             & it speed +"1300 Mhz"))
                  & it database (CREATE database inst *xdb1
                                  & it version +4.4.7)
                  & it "execution time" +"16.0 ms"
                  & it "download location"
                             +"www.xdb1.com/Example/Ex076.asp")
  & it solution (CREATE solution inst *"rm#2"
                  & it author hugo
                  & it hardware "desk top"
                  & it database (CREATE database inst *"sql server"
                                  & it version +2000)
                  & it "execution time" +"11.0 ms")
                  & it "download location"

+"http://groups-beta.google.com/group/comp.databases.object/msg/115bb5e14627fcd6")

(snip)

>// Find hugo's solution's execution time on hardware with 1300 Mhz CPU.
>// Finds 11.0 ms.
>(SELECT (solution inst *
>         & * author hugo
>         & * hardware (* cpu (* speed "1300 Mhz"))) "execution time" *)

// Find neo solution's execution time on same hardware // Finds 16.0 ms.
(SELECT (solution inst *

         & * author neo
         & * hardware (* cpu (* speed "1300 Mhz"))) "execution time" *)

// Note - challenge was for
//  "not more than 2X slower on equivalent hardware"

//(http://groups-beta.google.com/group/comp.databases.object/msg/1721e4f97931cb68) // ==> 2 X 16.0 ms = 32.0 ms < 11.0 ms

// Update neo's title.
(UPDATE neo title contender > cheater)

// Update hugo's title.
(UPDATE hugo title * > winner)

Best, Hugo

-- 

(Remove _NO_ and _SPAM_ to get my e-mail address)

Received on Mon Apr 04 2005 - 09:27:31 CEST