BlueBrain / nexus

Blue Brain Nexus - A knowledge graph for data-driven science
https://bluebrainnexus.io/
Apache License 2.0
280 stars 74 forks source link

Studio: Reload performance insufficient #3306

Open alex4200 opened 2 years ago

alex4200 commented 2 years ago

Describe the bug

When I reload a page in Fusion/Studio it took about 60 seconds (!!!) to reload the page. That is a totally inacceptable bad performance. Even 10 seconds would be bad already! That needs to fixed for usability of working with Fusion.

What part of Nexus is affected

To Reproduce Steps to reproduce the behavior, e.g. for Fusion:

  1. Go to 'Studio'
  2. Select a studio (in the example "test 62227") 3.reload the page

Expected behavior

Page should reload in like 5 seconds.

Screenshots

Screenshot 2022-05-27 at 13.07.33.png

Additional context env: stage Nexus Fusion v.1.8.0-M3-5-g7c346d1e user: adietz speedtest: 47.38 Mbps download, 31.92 Mbps upload

samuel-kerrien commented 2 years ago

Agreed, some queries when run on a SPARQL engine can run a long time. The reason for that is that this engine might not be suited for some kinds of queries (e.g. listing of numerous items). A work around (that is at the discretion of the user building the Studio) is to use Elasticsearch for such kinds of queries. In the future, we would like to leverage Search results (which run in Elasticsearch) to build a Studio Dashboard, both improving performance and making the creation of a Studio dashboard much easier (no need to write a SPARQL or Elasticsearch query).

I am relabelling this an enhancement rather than a bug.