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

> I changed my model ...
> the average execution time is now down to 11.0 ms.

XDb1 v4.5.4 takes 0.973 msec to generate the report in RAM only (does not include writing the report to hard disk). With SQL Server, can one generate the report to RAM only and measure the time? When running the report via Query Analyzer, does the reported time include writing table NCancestor to hard disk?

Data: Small hierarchy of 8 things (as published on web page). OS: Windows NT 4, sp6a
PC: Off-line, 500 Mhz, 512 MB, Dell PowerEdge,

       Dual Pentium, Dual Ultra SCSC II 10K RPM HDs. Setup: Restart PC, shut down all apps possible. Apps: XDb1 (v4.5.4) and Notepad.

Run Time Elapsed
--- -------------

1   0.972470 msec
2   0.973493 msec
3   0.974164 msec
4   0.972988 msec
5   0.972986 msec
6   0.973224 msec
7   0.969972 msec
8   0.977150 msec
9   0.971688 msec
10  0.971067 msec
-----------------