scenario bundel sparql queries are very slow

[wingechr]

@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

[jh-RLI]

Yes, this was a bad desicion due to lack of knowlage. We learned that you should not use rdflib like this. I already started to rework the backend to only use SPARQL to retrieve data form the OEKG. We have a few functionalies left which still use the "old" implementation.

Mainly the:

• scenario bundle widget, which is visilble on data table pages to show if the table is part of a bundle
• The OEO-Class viwer to browse the oeoe by URI / entity / relation. THis tool will be replaced with the TSS-Widgets as done in the OEO-Viewer already. Then we use the external TIB-Lookup Service.