Create performance tests for insert, update, delete nodes from denormalised table
Description
Activity
Test results with Query Accelerator enabled
Test | 1k nodes | 5k nodes | 10k nodes |
|---|---|---|---|
Insert nodes with properties in 1 table | 53s | 247s | 524s |
Remove aspect (remove from table) | 26s | 127s | 314s |
Add 2 aspects (insert in 2 tables) | 72s | 285s | 673s |
Delete nodes from 2 tables | 113s | 529s | 1180s |
Insert nodes without properties (folder structure) | 29s | 154s | 350s |
Add properties to nodes | 38s | 204s | 425s |
Delete nodes from 1 table | 118s | 616s | 1545s |
Test results with Query Accelerator disabled
Test | 1k nodes | 5k nodes | 10k nodes |
|---|---|---|---|
Insert nodes with properties in 1 table | 47s | 242s | 438s |
Remove aspect (remove from table) | 18s | 110s | 234s |
Add 2 aspects (insert in 2 tables) | 35s | 200s | 391s |
Delete nodes from 2 tables | 108s | 576s | 1088s |
Insert nodes without properties (folder structure) | 18s | 89s | 174s |
Add properties to nodes | 31s | 154s | 322s |
Delete nodes from 1 table | 126s | 586s | 1108s |
