Re: Nearest Common Ancestor Report (XDb1's $1000 Challenge)
Date: 4 Jun 2004 11:56:19 -0700
Message-ID: <4b45d3ad.0406041056.1c3b4fb1_at_posting.google.com>
> 1) Neo owes Hugo $1000
> 2) The International Bank Account Number (IBAN) of Hugo's bank account
> is NL59 RABO 0118 3365 68.
john isa name.
john isa string.
100 isa name.
100 isa integer.
3.14 isa name.
3.14 isa decimal.
god isa thing.
person isa thing.
* isa person. (an unnamed person) * parent god. (equal to '* isChildOf god.') * isa person. (another unnamed person) *'s name is john.
*'s name is 100.
*'s name is 3.14.
*'s parent god.
RM solutions thus far, lack the normalization and genericness to represent the above data. If RM's solution could be updated to accommodate the above, we will be one step closer to making a fairer comparison.
In all the measurements shown below, none of RM's solutions are normalized down to atomic symbols, where as XDb1's are.
Small Report Generation Summary (provided by Hugo)
Solution Time(ms) Platform Notes
-------------- -------- ----------------- -------------------------- RM#1 SqlSrvr2K 14.3 1.3 Ghz PC RM#2 SqlSrvr2K 11.0 1.3 Ghz PC XDb1 4.4.7 16 1.3 Ghz PC Unoptimized, debug version
Small Report Generation Summary (provided by Neo)
Solution Time(ms) Platform Notes
------------- -------- ----------------- -------------------------- RM#1 SqlSrvr7 65.0 500 Mhz Server RM#2 SqlSrvr7 68.9 500 Mhz Server RM#4 SqlSrvr7 152.13 500 Mhz Server XDb1 4.4.7 16 500 Mhz Server Unoptimized, debug version XDb1 4.5.7 1.632 500 Mhz Server XDb1 4.5.9 6.561 233 MHz PocketPC
Large Report (28,940 rows) Generation Summary (provided by Neo)
Solution Time(sec) Platform Notes
------------- -------- ----------------- -------------------------- RM#1 SqlSrvr7 15.2 500 Mhz Server XDb1 4.5.7 2.9 500 Mhz Server XDb1 4.5.9 16.971 233 Mhz PocketPCReceived on Fri Jun 04 2004 - 20:56:19 CEST