search

glasgowcompbio / ms2ldaviz

Substructural discovery in untargeted metabolomics data using LDA topic modelling.
http://ms2lda.org
MIT License
11 stars 8 forks source link

Summary page is slooooww #172

Closed joewandy closed 3 years ago

joewandy commented 3 years ago
  1. It's slow because of the 4 datatables, which load all the data when the page shows. We should change it so the table only loads what it needs. This probably needs quite a lot of work (changing views, templates, js etc).
  2. An interim solution is to simply cache the two big features and document tables, since they shouldn't change anymore once the data is created.
justinjjvanderhooft commented 3 years ago

Let's try the caching first....

joewandy commented 3 years ago

The view_parents page (used to display the details of a Mass2Motif) is also slow and can be sped up.

image

In fact, it can't even fully load for http://ms2lda.org/basicviz/view_parents/131944. Stuck while loading data for the fragmentation spectra plot as it generates an endless amount of SQL queries.

joewandy commented 3 years ago

FIxed in commits https://github.com/glasgowcompbio/ms2ldaviz/commit/bd18d193cc8ee8932cd5dacdbf7c4a3ce9db30a6, https://github.com/glasgowcompbio/ms2ldaviz/commit/89776988259516887d000ea4eda615bf96160553, and https://github.com/glasgowcompbio/ms2ldaviz/commit/f670f3b62b48945592bfd36c9c1deac2d076ce14. These pages now load much much faster.