Tweet
Tweet

Slide 1

Slide 1 text

Modeling TREES SQL-based MPTT Graphs VS.

Slide 2

Slide 2 text

No content

Slide 3

Slide 3 text

SQL DATABASES cannot compete with NoSQL ones in terms of performance

Slide 4

Slide 4 text

Sorry, Just JOKING around

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

But what about...

Slide 7

Slide 7 text

No content

Slide 8

Slide 8 text

1K times 1K instances 5 meters in each site

Slide 9

Slide 9 text

find root Leaf Root Branch MPTT GRAPH 8809 us 560 us ~16x faster

Slide 10

Slide 10 text

find parent Leaf Root Branch MPTT GRAPH 3823 us 626 us ~6x faster

Slide 11

Slide 11 text

find all ancestors Leaf Root Branch MPTT GRAPH 7668 us 2057 us ~4x faster

Slide 12

Slide 12 text

find immediate descendants Leaf Root Branch MPTT GRAPH 3522 us 810 us ~4x faster

Slide 13

Slide 13 text

find all descendants Leaf Root Branch MPTT GRAPH 5941 us 1033 us ~6x faster

Slide 14

Slide 14 text

fetch descendants tree Leaf Root Branch MPTT GRAPH 6069 us 1802 us ~3x faster

Slide 15

Slide 15 text

No content