search

VEuPathDB / web-monorepo

A monorepo that contains all frontend code for VEuPathDB websites
Apache License 2.0
2 stars 0 forks source link

Genomic: JBrowse: improve loading speed #987

Open aurreco-uga opened 7 months ago

aurreco-uga commented 7 months ago

intron table based on slimmer wdk page at https://redmine.apidb.org/issues/52973

UX April 3 2024 DR complains of performance loading time. compare the old intron popup in prod with the new one in qa: (click on an intron in the RNASeq intron track)

  1. https://qa.plasmodb.org/plasmo.b68/jbrowse/index.html?data=%2Fa%2Fservice%2Fjbrowse%2Ftracks%2Fdefault&loc=Pf3D7_11_v3%3A1277962..1311692&tracks=RNA-Seq%20Evidence%20for%20Introns&highlight=
  2. https://plasmodb.org/plasmo/jbrowse/index.html?data=%2Fa%2Fservice%2Fjbrowse%2Ftracks%2Fdefault&loc=Pf3D7_11_v3%3A1402271..1435256&tracks=RNA-Seq%20Evidence%20for%20Introns&highlight=
Screenshot 2024-04-03 at 12 20 55 PM
aurreco-uga commented 7 months ago

i noticed that most of the time is spent in the SQL to get the table about 3sec, we should ask steve /JB to check.

*** File: /usr/local/tomcat_instances/PlasmoDB/logs/plasmo.b68/queries-slow.log [20/Apr/2024|16:32:08] rid: 1126 3242ms 47.32.74.105 - WARN - org.gusdb.fgputil.db.slowquery.QueryLogger:131 - QUERY LOG first: 2.988 last: 2.989 [JunctionTables.SampleInfo__select-uncached]

Screenshot 2024-04-20 at 4 30 33 PM
dmfalke commented 6 months ago

the iframe method is never going to be as fast as the other method, but we do have some options for speeding things up, in ascending order of improvement:

  1. ~ensure that we are rendering content as soon as we have data. it looks like we are currently blocking rendering until we get user preferences, etc~ this has been done, in part. it did not render huge savings.
  2. make a dedicated page in our existing client application for jbrowse, that removes some functionality which requires loading user preferences. this will still load the enormous javascript and css bundle used by the website
  3. make a new client application that is fine tuned for displaying record pages