Gustavo Picon is sharing code with you

Bitbucket is a code hosting site. Unlimited public and private repositories. Free for small teams.

Don't show this again

tabo / django-treebeard

Efficient tree implementations for Django 1.0+ :: https://tabo.pe/projects/django-treebeard/

Clone this repository (size: 646.5 KB): HTTPS / SSH 
hg clone https://bitbucket.org/tabo/django-treebeard
hg clone ssh://hg@bitbucket.org/tabo/django-treebeard

django-treebeard / tbbench / tbbench-sqlite

  • 9b9ca1a49244
  • 67 loc
  • 3.3 KB
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67

* DATABASE USED: s

+-------------+--------------+---------+---------+
| Inserts     | TB MP        |    2205 |    1934 |
|             +--------------+---------+---------+
|             | TB AL        |    1583 |    1457 |
|             +--------------+---------+---------+
|             | TB NS        |    2794 |    2554 |
|             +--------------+---------+---------+
|             | MPTT         |    3781 |    3484 |
|             +--------------+---------+---------+
|             | TB MP Sorted |    3250 |    3045 |
|             +--------------+---------+---------+
|             | TB AL Sorted |     860 |     705 |
|             +--------------+---------+---------+
|             | TB NS Sorted |    5907 |    5461 |
|             +--------------+---------+---------+
|             | MPTT Sorted  |    4842 |    4284 |
+-------------+--------------+---------+---------+
| Descendants | TB MP        |   10415 |     N/A |
|             +--------------+---------+---------+
|             | TB AL        |   50521 |     N/A |
|             +--------------+---------+---------+
|             | TB NS        |    5965 |     N/A |
|             +--------------+---------+---------+
|             | MPTT         |    5197 |     N/A |
|             +--------------+---------+---------+
|             | TB MP Sorted |   10513 |     N/A |
|             +--------------+---------+---------+
|             | TB AL Sorted |   53458 |     N/A |
|             +--------------+---------+---------+
|             | TB NS Sorted |    6026 |     N/A |
|             +--------------+---------+---------+
|             | MPTT Sorted  |    5333 |     N/A |
+-------------+--------------+---------+---------+
| Move        | TB MP        |     497 |     468 |
|             +--------------+---------+---------+
|             | TB AL        |    7051 |    6863 |
|             +--------------+---------+---------+
|             | TB NS        |     672 |     637 |
|             +--------------+---------+---------+
|             | MPTT         |     921 |     896 |
|             +--------------+---------+---------+
|             | TB MP Sorted |    2622 |    2487 |
|             +--------------+---------+---------+
|             | TB AL Sorted |    3491 |    3416 |
|             +--------------+---------+---------+
|             | TB NS Sorted |    1543 |    1496 |
|             +--------------+---------+---------+
|             | MPTT Sorted  |     957 |     955 |
+-------------+--------------+---------+---------+
| Delete      | TB MP        |     636 |     557 |
|             +--------------+---------+---------+
|             | TB AL        |     843 |     921 |
|             +--------------+---------+---------+
|             | TB NS        |     530 |     513 |
|             +--------------+---------+---------+
|             | MPTT         |    1617 |    1635 |
|             +--------------+---------+---------+
|             | TB MP Sorted |     612 |     565 |
|             +--------------+---------+---------+
|             | TB AL Sorted |     884 |     859 |
|             +--------------+---------+---------+
|             | TB NS Sorted |     501 |     490 |
|             +--------------+---------+---------+
|             | MPTT Sorted  |    2024 |    1787 |
+-------------+--------------+---------+---------+