Comparing
fac-ipam-prefix-reconcile-perf-improvement
(79a1610
) withstable
(f9dfb54
)0%
- Improvements
- 0
- Regressions
- 0
- Untouched
- 10
- New
- 0
- Dropped
- 0
- Ignored
- 2
Benchmarks
Passed
test_query_one_model
backend/tests/benchmark/test_graphql_query.py::test_query_one_model0%
348 ms
346.8 ms
test_relationshipmanager_getpeer
backend/tests/benchmark/test_nodemanager_peers.py::test_relationshipmanager_getpeer0%
2.4 ms
2.4 ms
test_nodemanager_querypeers
backend/tests/benchmark/test_nodemanager_peers.py::test_nodemanager_querypeers0%
1.6 ms
1.6 ms
test_load_node_to_db_node_schema
backend/tests/benchmark/test_load_node_to_db.py::test_load_node_to_db_node_schema0%
57 ms
57.1 ms
test_query_rel_one
backend/tests/benchmark/test_graphql_query.py::test_query_rel_one0%
556 ms
557 ms
test_graphql_generate_schema
backend/tests/benchmark/test_graphql_generate_schema.py::test_graphql_generate_schema0%
322.9 ms
323.6 ms
test_get_schema
backend/tests/benchmark/test_get_schema.py::test_get_schema0%
236.9 ms
237.5 ms
test_base_schema_duplicate_CoreProposedChange
backend/tests/benchmark/test_nodeschema_duplicate.py::test_base_schema_duplicate_CoreProposedChange0%
1.5 ms
1.5 ms
test_schemabranch_process
backend/tests/benchmark/test_schemabranch_process.py::test_schemabranch_process-1%
597 ms
600.7 ms
Ignored
test_query_rel_manyIgnored
backend/tests/benchmark/test_graphql_query.py::test_query_rel_many+1%
560.4 ms
557.5 ms
test_schemabranch_duplicateIgnored
backend/tests/benchmark/test_schemabranch_duplicate.py::test_schemabranch_duplicate+11%
388.4 µs
349.4 µs
Commits
Click on a commit to change the comparison rangeBase
stable
f9dfb54
0%
fix(backend): improve IPPrefixReconcileQuery performance
By directly filtering the node labels. Using WHERE in labels() did not
trigger the NodeByLabelScan and thus processed all nodes.
Also add a WHERE IN clause for the binary address lookup so that the
binary address index is effectively used.
Looking up for the binary address + prefix length tuple prevented the
planner from using the index.
Signed-off-by: Fatih Acar <fatih@opsmill.com>
79a1610
2 months ago
by fatih-acar