Re: Nearest Common Ancestor Report (XDb1's $1000 Challenge)

From: Neo <neo55592_at_hotmail.com>
Date: 6 Jun 2004 15:05:15 -0700
Message-ID: <4b45d3ad.0406061405.5a5f7310@posting.google.com>

> Additionally, no one knows how much he tuned his product to win,
> even to the point of hardcoding output, prior to issuing the challenge.

To find out, why not propose a new hierarchy and compare results?

> The relational model was invented and published over thirty years ago.
> In all that time, there has been no serious challenger for an alternate
> data model.

Why not show that XDb1 is no serious challenger by either using RM Solution #1 or #2 to create a report for the three thing hierarchy or by providing an alternate solution.

> Neo had every chance to select the absolute best problem to illustrate
> how his 'thing' (XDb1) is better than an off-the-shelf SQL DBMS. He failed!

Below are measurements made thus far using RM solutions that aren't as generic or normalized as XDb1's.

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        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
XDb1 4.4.7      16       500 Mhz Server    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#5 SqlSrvr7   40.5     500 Mhz Server
XDb1 4.5.7       2.9     500 Mhz Server
XDb1 4.5.9      16.971   233 Mhz PocketPC

Received on Sun Jun 06 2004 - 17:05:15 CDT