Revision 715
Added by bojilova over 23 years ago
| test/test-results.txt | ||
|---|---|---|
| 1 |
SQL> select count(*) from xml_nodes; |
|
| 2 |
|
|
| 3 |
COUNT(*) |
|
| 4 |
--------- |
|
| 5 |
11889 |
|
| 6 |
|
|
| 7 |
---------------------TSTMT------------------ |
|
| 8 |
TSTMT INDEXED DEPTH 0 17.48 16.616 0.864 1 |
|
| 9 |
TSTMT INDEXED DEPTH 1 4.325 3.793 0.532 1 |
|
| 10 |
TSTMT INDEXED DEPTH 2 6.311 5.698 0.613 1 |
|
| 11 |
TSTMT INDEXED DEPTH 3 1.54 1.002 0.538 1 |
|
| 12 |
TSTMT INDEXED DEPTH 4 1.538 1.015 0.523 1 |
|
| 13 |
TSTMT INDEXED DEPTH 5 1.587 0.961 0.626 1 |
|
| 14 |
TSTMT INDEXED DEPTH 6 1.52 0.92 0.6 1 |
|
| 15 |
TSTMT NONINDEXED DEPTH 0 1.814 1.086 0.728 1 |
|
| 16 |
TSTMT NONINDEXED DEPTH 1 5.934 5.379 0.555 1 |
|
| 17 |
TSTMT NONINDEXED DEPTH 2 1.486 0.869 0.617 1 |
|
| 18 |
TSTMT NONINDEXED DEPTH 3 1.437 0.829 0.608 1 |
|
| 19 |
TSTMT NONINDEXED DEPTH 4 1.608 1.016 0.592 1 |
|
| 20 |
TSTMT NONINDEXED DEPTH 5 1.814 0.988 0.826 1 |
|
| 21 |
TSTMT NONINDEXED DEPTH 6 2.353 1.497 0.856 1 |
|
| 22 |
------------- |
|
| 23 |
TEST COMPLETE |
|
| 24 |
------------- |
|
| 25 |
|
|
| 26 |
SQL> select count(*) from xml_nodes; |
|
| 27 |
|
|
| 28 |
COUNT(*) |
|
| 29 |
--------- |
|
| 30 |
87054 |
|
| 31 |
|
|
| 32 |
---------------------TSTMT------------------ |
|
| 33 |
TSTMT INDEXED DEPTH 0 3.736 0.876 2.86 1 |
|
| 34 |
TSTMT INDEXED DEPTH 1 1.322 0.801 0.521 1 |
|
| 35 |
TSTMT INDEXED DEPTH 2 1.296 0.769 0.527 1 |
|
| 36 |
TSTMT INDEXED DEPTH 3 1.296 0.8 0.496 1 |
|
| 37 |
TSTMT INDEXED DEPTH 4 1.35 0.771 0.579 1 |
|
| 38 |
TSTMT INDEXED DEPTH 5 1.486 0.805 0.681 1 |
|
| 39 |
TSTMT INDEXED DEPTH 6 1.316 0.802 0.514 1 |
|
| 40 |
TSTMT NONINDEXED DEPTH 0 3.714 0.886 2.828 1 |
|
| 41 |
TSTMT NONINDEXED DEPTH 1 1.297 0.803 0.494 1 |
|
| 42 |
TSTMT NONINDEXED DEPTH 2 1.3 0.773 0.527 1 |
|
| 43 |
TSTMT NONINDEXED DEPTH 3 1.298 0.803 0.495 1 |
|
| 44 |
TSTMT NONINDEXED DEPTH 4 1.303 0.772 0.531 1 |
|
| 45 |
TSTMT NONINDEXED DEPTH 5 1.455 0.803 0.652 1 |
|
| 46 |
TSTMT NONINDEXED DEPTH 6 1.301 0.803 0.498 1 |
|
| 47 |
------------- |
|
| 48 |
TEST COMPLETE |
|
| 49 |
------------- |
|
| 50 |
|
|
| 51 |
SQL> select count(*) from xml_nodes; |
|
| 52 |
|
|
| 53 |
COUNT(*) |
|
| 54 |
--------- |
|
| 55 |
162219 |
|
| 56 |
|
|
| 57 |
---------------------TSTMT------------------ |
|
| 58 |
TSTMT INDEXED DEPTH 0 5.85 0.878 4.972 2 |
|
| 59 |
TSTMT INDEXED DEPTH 1 1.296 0.768 0.528 2 |
|
| 60 |
TSTMT INDEXED DEPTH 2 1.306 0.802 0.504 2 |
|
| 61 |
TSTMT INDEXED DEPTH 3 1.361 0.824 0.537 2 |
|
| 62 |
TSTMT INDEXED DEPTH 4 1.307 0.802 0.505 2 |
|
| 63 |
TSTMT INDEXED DEPTH 5 1.663 0.801 0.862 2 |
|
| 64 |
TSTMT INDEXED DEPTH 6 1.31 0.771 0.539 2 |
|
| 65 |
TSTMT NONINDEXED DEPTH 0 5.821 0.806 5.015 2 |
|
| 66 |
TSTMT NONINDEXED DEPTH 1 1.3 0.769 0.531 2 |
|
| 67 |
TSTMT NONINDEXED DEPTH 2 1.367 0.863 0.504 2 |
|
| 68 |
TSTMT NONINDEXED DEPTH 3 1.305 0.798 0.507 2 |
|
| 69 |
TSTMT NONINDEXED DEPTH 4 1.307 0.802 0.505 2 |
|
| 70 |
TSTMT NONINDEXED DEPTH 5 1.72 0.855 0.865 2 |
|
| 71 |
TSTMT NONINDEXED DEPTH 6 1.304 0.77 0.534 2 |
|
| 72 |
------------- |
|
| 73 |
TEST COMPLETE |
|
| 74 |
------------- |
|
| 0 | 75 | |
Also available in: Unified diff
test results for 11thousands, 87thousands and 162 thousands nodes