Re: Demo: Things in Hierarchies (w/o RM/SQL)

On 8 Nov 2004 10:49:46 -0800, neo55592_at_hotmail.com (Neo) wrote:

>> The fact is that you issued a challenge, and promised to pay a
>> substantial sum to anyone who could meet it.
>
>Hugo's RM Solution #1 and #2 failed to meet the challenge because they
>are nearly twice as slow as XDb1's even when XDb1 is executed on 5.6X
>slower hardware. See measurements below. You are weclome to download
>XDb1 (www.xdb1/example/ex076.asp) and verify measurements against
>Hugo's solutions.
>
>Not only were Hugo's solutions slower, but there were not as generic
>or normalized. For instance, Hugo's solution cannot represent the
>following cases without NULLs or redundant data (XDb1's solution is
>normalized down to atomic symbols):
>
>Case1: God is the parent of an unnamed person. God is also the parent
>of second person with three names (string 'john', integer 100, decimal
>3.14).
>
>Case2: john isa person. john's color is brown. mary isa person. mary's
>color is brown. brown is a person.
>
>As shown by the measurements made below, even when executed on a 5.6
>times slower 233 Mhz Pocket PC, XDb1 generated the small common
>ancestor report nearly twice as fast as Hugo's non-normalized,
>non-generic SQL Server 2000 Solution running on a 1,300 MHz desktop.
>
>Small Report Generation Summary (provided by Hugo)
>---------------------------------------------------------------------
>Solution Time(ms) Platform Notes
>-------------- -------- ----------------- --------------------------
>RM#1 SqlSrvr2K 14.3 1.3 Ghz PC Unnormalized, non-generic
>RM#2 SqlSrvr2K 11.0 1.3 Ghz PC Unnormalized, non-generic
>
>
>Small Report Generation Summary (provided by Neo)
>---------------------------------------------------------------------
>Solution Time(ms) Platform Notes
>------------- -------- ----------------- --------------------------
>RM#1 SqlSrvr7 65.0 500 Mhz Server Unnormalized, non-generic
>RM#2 SqlSrvr7 68.9 500 Mhz Server Unnormalized, non-generic
>XDb1 4.5.7 1.632 500 Mhz Server Normalized, generic
>XDb1 4.5.9 6.561 233 MHz PocketPC Normalized, generic
>
>
>Large Report (28,940 rows) Generation Summary (provided by Neo)
>200 Goat Hierarchy (5 generations x 40 goats/generation,
>each goat having two parents, except 1st gen).
>---------------------------------------------------------------------
>Solution Time(sec) Platform Notes
>------------- -------- ----------------- --------------------------
>RM#5 SqlSrvr7 40.5 500 Mhz Server Unnormalized, non-generic
>XDb1 4.5.7 2.9 500 Mhz Server Normalized, generic
>XDb1 4.5.9 16.971 233 Mhz PocketPC Normalized, generic
>
>
>Larger Report (276,620 rows) Generation Summary (provided by Neo).
>400 Goat Hierarchy (10 gen x 40 goats/gen),
>---------------------------------------------------------------------
>Solution Time(ms) Platform Notes
>------------- -------- ----------------- --------------------------
>RM#5 SqlSrvr7 105 min 500 Mhz Srvr, NT Avg of 2 runs, UnNrm,UnGen
>XDb1 4.5.10 44 min 500 Mhz Srvr, NT Avg of 2 runs, Norm, gener
>XDb1 4.5.10 57 min 450 Mhz PC, 98 1 run, Normalized, generic
>XDb1 4.5.10 195 min 233 Mhz PocketPC 1 run, Normalized, generic

Copy and paste again, eh? Ok:

The fact is that you issued a challenge, and promised to pay a substantial sum to anyone who could meet it. Hugo met the challenge, and then you changed the rules. Hugo again met the new challenge, so you changed the rules again. You are in default, you know you are in default, and this makes you a fraud. Please pay Hugo and perhaps people will stop calling you a fraud.

Lemming

-- 
Curiosity *may* have killed Schrodinger's cat.