visualization-tool icon indicating copy to clipboard operation
visualization-tool copied to clipboard
verified publisher icon visualize-admin

poor SPARQL query performance

Open Rdataflow opened this issue 2 years ago • 0 comments

Describe the bug First time loading this cube suffers from bad SPARQL query performance due to bad query. The user has to wait ~5000ms longer to have the chart fully loaded due to such kind of queries.

To Reproduce Steps to reproduce the behavior:

  1. Wait for the LRU cache to be empty
  2. Go to https://int.visualize.admin.ch/create/new?cube=https://environment.ld.admin.ch/foen/nfi/49-20-21/cube/1&debug=true
  3. Click on the debug symbol
  4. Open DataCubeMetadataWithComponentValues
  5. See slowest / topmost SPARQL query (~5000ms)

Expected behavior quick query

Environment (please complete the following information):

  • Visualize environment and version: [e.g. INT v3.19.5]

Additional context

  • reason: poor SPARQL query performance
  • robust optimization is needed

Rdataflow avatar Feb 17 '23 10:02 Rdataflow

Im using it with ethernet, it just works, im using a WT32-ETH01 board

welrestedgenius avatar Mar 16 '22 13:03 welrestedgenius