Commits

Gustavo Picon committed 8429986

updating tbbench results

Comments (0)

Files changed (5)

tbbench/tbbench-innodb

 * DATABASE USED: mi
 
 +-------------+--------------+---------+---------+
-| Inserts     | TB MP        |    3194 |    2661 |
+| Inserts     | TB MP        |    3220 |    2660 |
 |             +--------------+---------+---------+
-|             | TB AL        |    1976 |    1931 |
+|             | TB AL        |    1963 |    1905 |
 |             +--------------+---------+---------+
-|             | MPTT         |    7030 |    9189 |
+|             | TB NS        |    3386 |    3438 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    4549 |    5532 |
+|             | MPTT         |    7559 |    9280 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |    1308 |    1031 |
+|             | TB MP Sorted |    4732 |    5627 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    8055 |    9551 |
+|             | TB AL Sorted |    1096 |    1052 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    6637 |    6373 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    8564 |   10729 |
 +-------------+--------------+---------+---------+
-| Descendants | TB MP        |    6245 |     N/A |
+| Descendants | TB MP        |    6298 |     N/A |
 |             +--------------+---------+---------+
-|             | TB AL        |   57767 |     N/A |
+|             | TB AL        |   56850 |     N/A |
 |             +--------------+---------+---------+
-|             | MPTT         |    5332 |     N/A |
+|             | TB NS        |    5595 |     N/A |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    6806 |     N/A |
+|             | MPTT         |    5268 |     N/A |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |   58547 |     N/A |
+|             | TB MP Sorted |    6698 |     N/A |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    5163 |     N/A |
+|             | TB AL Sorted |   59817 |     N/A |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    5631 |     N/A |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    5186 |     N/A |
 +-------------+--------------+---------+---------+
-| Move        | TB MP        |     874 |    1008 |
+| Move        | TB MP        |     837 |    1156 |
 |             +--------------+---------+---------+
-|             | TB AL        |    8870 |    8767 |
+|             | TB AL        |    8708 |    8684 |
 |             +--------------+---------+---------+
-|             | MPTT         |    6222 |    7419 |
+|             | TB NS        |     683 |     658 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    7308 |    7026 |
+|             | MPTT         |    6449 |    7793 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |    4046 |    3707 |
+|             | TB MP Sorted |    6730 |    7036 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    6943 |   11181 |
+|             | TB AL Sorted |    3866 |    3731 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    2017 |    2017 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    6563 |   10540 |
 +-------------+--------------+---------+---------+
-| Delete      | TB MP        |     738 |     644 |
+| Delete      | TB MP        |     714 |     651 |
 |             +--------------+---------+---------+
-|             | TB AL        |     978 |    1085 |
+|             | TB AL        |     975 |    1093 |
 |             +--------------+---------+---------+
-|             | MPTT         |    2839 |    4973 |
+|             | TB NS        |     745 |     745 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |     813 |     757 |
+|             | MPTT         |    2928 |    4473 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |    1022 |    1007 |
+|             | TB MP Sorted |     811 |     751 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    4687 |    6370 |
+|             | TB AL Sorted |    1030 |    1030 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |     756 |     750 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    3729 |    5108 |
 +-------------+--------------+---------+---------+

tbbench/tbbench-myisam

 * DATABASE USED: mm
 
 +-------------+--------------+---------+---------+
-| Inserts     | TB MP        |    3210 |    2676 |
+| Inserts     | TB MP        |    3181 |    2766 |
 |             +--------------+---------+---------+
-|             | TB AL        |    1941 |    1935 |
+|             | TB AL        |    1998 |    1936 |
 |             +--------------+---------+---------+
-|             | MPTT         |    7015 |    9206 |
+|             | TB NS        |    3359 |    3420 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    4087 |    5731 |
+|             | MPTT         |    7525 |    9028 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |    1077 |    1012 |
+|             | TB MP Sorted |    5038 |    5215 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    8113 |   10615 |
+|             | TB AL Sorted |    1092 |    1033 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    6283 |    6313 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    7947 |   10221 |
 +-------------+--------------+---------+---------+
-| Descendants | TB MP        |    6377 |     N/A |
+| Descendants | TB MP        |    6460 |     N/A |
 |             +--------------+---------+---------+
-|             | TB AL        |   56616 |     N/A |
+|             | TB AL        |  116550 |     N/A |
 |             +--------------+---------+---------+
-|             | MPTT         |    5344 |     N/A |
+|             | TB NS        |    5824 |     N/A |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    6818 |     N/A |
+|             | MPTT         |    5306 |     N/A |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |   58055 |     N/A |
+|             | TB MP Sorted |    6408 |     N/A |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    5443 |     N/A |
+|             | TB AL Sorted |   59718 |     N/A |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    5858 |     N/A |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    5453 |     N/A |
 +-------------+--------------+---------+---------+
-| Move        | TB MP        |     781 |    1131 |
+| Move        | TB MP        |     992 |    1211 |
 |             +--------------+---------+---------+
-|             | TB AL        |    8833 |    8858 |
+|             | TB AL        |    9798 |    8890 |
 |             +--------------+---------+---------+
-|             | MPTT         |    6505 |    7666 |
+|             | TB NS        |     660 |     679 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    6879 |    7312 |
+|             | MPTT         |    6356 |    7003 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |    3959 |    3636 |
+|             | TB MP Sorted |    6743 |    7023 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    6646 |   10331 |
+|             | TB AL Sorted |    3873 |    3717 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    1958 |    2078 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    6427 |    9358 |
 +-------------+--------------+---------+---------+
-| Delete      | TB MP        |     713 |     655 |
+| Delete      | TB MP        |     733 |     686 |
 |             +--------------+---------+---------+
-|             | TB AL        |     987 |    1099 |
+|             | TB AL        |    2199 |     991 |
 |             +--------------+---------+---------+
-|             | MPTT         |    2902 |    3453 |
+|             | TB NS        |     742 |     763 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |     875 |     737 |
+|             | MPTT         |    2914 |    4814 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |    1001 |     998 |
+|             | TB MP Sorted |     808 |     737 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    4355 |    4112 |
+|             | TB AL Sorted |    1055 |     987 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |     728 |     758 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    3833 |    4776 |
 +-------------+--------------+---------+---------+

tbbench/tbbench-pg82

 * DATABASE USED: p82
 
 +-------------+--------------+---------+---------+
-| Inserts     | TB MP        |    2958 |    2585 |
+| Inserts     | TB MP        |    2859 |    2542 |
 |             +--------------+---------+---------+
-|             | TB AL        |    1940 |    1772 |
+|             | TB AL        |    1937 |    1775 |
 |             +--------------+---------+---------+
-|             | MPTT         |    5213 |   16115 |
+|             | TB NS        |    4061 |    7242 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    3943 |    5638 |
+|             | MPTT         |    5202 |   14969 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |    1182 |     988 |
+|             | TB MP Sorted |    4022 |    4808 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    6117 |    8962 |
+|             | TB AL Sorted |    1239 |     999 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    7548 |   10053 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    6077 |    7567 |
 +-------------+--------------+---------+---------+
-| Descendants | TB MP        |    7822 |     N/A |
+| Descendants | TB MP        |    7643 |     N/A |
 |             +--------------+---------+---------+
-|             | TB AL        |   55590 |     N/A |
+|             | TB AL        |   54249 |     N/A |
 |             +--------------+---------+---------+
-|             | MPTT         |    9603 |     N/A |
+|             | TB NS        |   10080 |     N/A |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    8100 |     N/A |
+|             | MPTT         |    9394 |     N/A |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |   55914 |     N/A |
+|             | TB MP Sorted |    8248 |     N/A |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    9661 |     N/A |
+|             | TB AL Sorted |   56767 |     N/A |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    9980 |     N/A |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    9723 |     N/A |
 +-------------+--------------+---------+---------+
-| Move        | TB MP        |     756 |    1049 |
+| Move        | TB MP        |     745 |    1040 |
 |             +--------------+---------+---------+
-|             | TB AL        |    7263 |    7209 |
+|             | TB AL        |    7243 |    7213 |
 |             +--------------+---------+---------+
-|             | MPTT         |    5270 |   22285 |
+|             | TB NS        |    1266 |    2000 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    6241 |   23016 |
+|             | MPTT         |    4993 |   20743 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |    3570 |    3560 |
+|             | TB MP Sorted |    6410 |   19294 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    5060 |   18968 |
+|             | TB AL Sorted |    3587 |    3599 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    4397 |    7981 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    5132 |   20426 |
 +-------------+--------------+---------+---------+
-| Delete      | TB MP        |     706 |     696 |
+| Delete      | TB MP        |     699 |     689 |
 |             +--------------+---------+---------+
-|             | TB AL        |     754 |     848 |
+|             | TB AL        |     758 |     847 |
 |             +--------------+---------+---------+
-|             | MPTT         |   82047 |  148736 |
+|             | TB NS        |     555 |     698 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |     932 |    1052 |
+|             | MPTT         |   69385 |  167777 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |     787 |     768 |
+|             | TB MP Sorted |     798 |    1180 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |   58553 |  139216 |
+|             | TB AL Sorted |     797 |    1023 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |     807 |     847 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |   86545 |  148596 |
 +-------------+--------------+---------+---------+

tbbench/tbbench-pg83

 * DATABASE USED: p83
 
 +-------------+--------------+---------+---------+
-| Inserts     | TB MP        |    2515 |    2343 |
+| Inserts     | TB MP        |    2540 |    2309 |
 |             +--------------+---------+---------+
-|             | TB AL        |    1749 |    1640 |
+|             | TB AL        |    1736 |    1631 |
 |             +--------------+---------+---------+
-|             | MPTT         |    4657 |    9259 |
+|             | TB NS        |    3536 |    4401 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    3549 |    3845 |
+|             | MPTT         |    4764 |    6022 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |    1035 |     881 |
+|             | TB MP Sorted |    3415 |    3942 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    5563 |    6307 |
+|             | TB AL Sorted |    1049 |     896 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    6717 |   10941 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    5490 |    6894 |
 +-------------+--------------+---------+---------+
-| Descendants | TB MP        |    7168 |     N/A |
+| Descendants | TB MP        |    7132 |     N/A |
 |             +--------------+---------+---------+
-|             | TB AL        |   51321 |     N/A |
+|             | TB AL        |   50682 |     N/A |
 |             +--------------+---------+---------+
-|             | MPTT         |    5439 |     N/A |
+|             | TB NS        |    5840 |     N/A |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    7720 |     N/A |
+|             | MPTT         |    8745 |     N/A |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |   52505 |     N/A |
+|             | TB MP Sorted |    7265 |     N/A |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    8930 |     N/A |
+|             | TB AL Sorted |   52574 |     N/A |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    9210 |     N/A |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    8912 |     N/A |
 +-------------+--------------+---------+---------+
-| Move        | TB MP        |     617 |     754 |
+| Move        | TB MP        |     603 |     740 |
 |             +--------------+---------+---------+
-|             | TB AL        |    6842 |    6821 |
+|             | TB AL        |    6721 |    6757 |
 |             +--------------+---------+---------+
-|             | MPTT         |    3383 |    7052 |
+|             | TB NS        |     650 |     907 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    3623 |   12396 |
+|             | MPTT         |    4445 |    8977 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |    3409 |    3349 |
+|             | TB MP Sorted |    3622 |   12380 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    4650 |    8174 |
+|             | TB AL Sorted |    3394 |    3371 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    3892 |    8110 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    4601 |    9428 |
 +-------------+--------------+---------+---------+
-| Delete      | TB MP        |     604 |     566 |
+| Delete      | TB MP        |     595 |     561 |
 |             +--------------+---------+---------+
-|             | TB AL        |     728 |     834 |
+|             | TB AL        |     714 |     804 |
 |             +--------------+---------+---------+
-|             | MPTT         |   15706 |   21539 |
+|             | TB NS        |     430 |     506 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |     629 |     753 |
+|             | MPTT         |   18186 |   26270 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |     748 |     719 |
+|             | TB MP Sorted |     648 |    1101 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |   15206 |  106658 |
+|             | TB AL Sorted |     760 |     969 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |     576 |     748 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |   34059 |  127125 |
 +-------------+--------------+---------+---------+

tbbench/tbbench-sqlite

 * DATABASE USED: s
 
 +-------------+--------------+---------+---------+
-| Inserts     | TB MP        |    2257 |    1937 |
+| Inserts     | TB MP        |    2205 |    1934 |
 |             +--------------+---------+---------+
-|             | TB AL        |    1554 |    1485 |
+|             | TB AL        |    1583 |    1457 |
 |             +--------------+---------+---------+
-|             | MPTT         |    3532 |    3119 |
+|             | TB NS        |    2794 |    2554 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    3175 |    2895 |
+|             | MPTT         |    3781 |    3484 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |     848 |     704 |
+|             | TB MP Sorted |    3250 |    3045 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    4636 |    4195 |
+|             | TB AL Sorted |     860 |     705 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    5907 |    5461 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    4842 |    4284 |
 +-------------+--------------+---------+---------+
-| Descendants | TB MP        |   10652 |     N/A |
+| Descendants | TB MP        |   10415 |     N/A |
 |             +--------------+---------+---------+
-|             | TB AL        |   51235 |     N/A |
+|             | TB AL        |   50521 |     N/A |
 |             +--------------+---------+---------+
-|             | MPTT         |    5382 |     N/A |
+|             | TB NS        |    5965 |     N/A |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |   10725 |     N/A |
+|             | MPTT         |    5197 |     N/A |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |   51991 |     N/A |
+|             | TB MP Sorted |   10513 |     N/A |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    5192 |     N/A |
+|             | TB AL Sorted |   53458 |     N/A |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    6026 |     N/A |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    5333 |     N/A |
 +-------------+--------------+---------+---------+
-| Move        | TB MP        |     490 |     465 |
+| Move        | TB MP        |     497 |     468 |
 |             +--------------+---------+---------+
-|             | TB AL        |    7187 |    7008 |
+|             | TB AL        |    7051 |    6863 |
 |             +--------------+---------+---------+
-|             | MPTT         |     894 |     879 |
+|             | TB NS        |     672 |     637 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |    2514 |    2451 |
+|             | MPTT         |     921 |     896 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |    3671 |    3355 |
+|             | TB MP Sorted |    2622 |    2487 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |     927 |     922 |
+|             | TB AL Sorted |    3491 |    3416 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |    1543 |    1496 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |     957 |     955 |
 +-------------+--------------+---------+---------+
-| Delete      | TB MP        |     623 |     561 |
+| Delete      | TB MP        |     636 |     557 |
 |             +--------------+---------+---------+
-|             | TB AL        |     846 |     944 |
+|             | TB AL        |     843 |     921 |
 |             +--------------+---------+---------+
-|             | MPTT         |    1648 |    1659 |
+|             | TB NS        |     530 |     513 |
 |             +--------------+---------+---------+
-|             | TB MP Sorted |     579 |     544 |
+|             | MPTT         |    1617 |    1635 |
 |             +--------------+---------+---------+
-|             | TB AL Sorted |     867 |     852 |
+|             | TB MP Sorted |     612 |     565 |
 |             +--------------+---------+---------+
-|             | MPTT Sorted  |    1986 |    1743 |
+|             | TB AL Sorted |     884 |     859 |
+|             +--------------+---------+---------+
+|             | TB NS Sorted |     501 |     490 |
+|             +--------------+---------+---------+
+|             | MPTT Sorted  |    2024 |    1787 |
 +-------------+--------------+---------+---------+