OpenEnergyPlatform / OpenEnergyPlatform/oeplatform

scenario bundel sparql queries are very slow

Open
#2,197 1 comment 0 reactions 1 assignee View on GitHub

@jh-RLI is already working on this.

Since Dec 22, 2025.

Dominant language
Python
Stars
65
Forks
29
Avg merge
15h 25m
Merged PRs (30d)
32

Description

@jh-RLI maybe the performance issues are related to the filter_scenario_bundles_view. executing it locally, it takes very long and fuseki spams a LOT of executed queries. there is a lot of nested loops, like here:

scenario_bundles_input = set()

        for bundle, _, _ in self.oekg.triples(
            (None, RDF.type, namespaces.OEO.OEO_00020227)
        ):
            for scen in related_scenarios_input:
                for s1, _, _ in self.oekg.triples(
                    (bundle, namespaces.OBO.BFO_0000051, scen)
                ):
                    if s1:
                        scenario_bundles_input.add((s1, bundle))

Originally posted by @wingechr in #2189

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.