Issue# 66 - Summary page updates

reynoldtan commented 5 years ago

Speed up loading of rawdata heatmap summary chart.

reynoldtan commented 5 years ago

Issue# 66 - Summary page updates

Speed up page load time of summary chart. Currently, the summary chart takes 2 mins more or less to render 403K+ data points. With more and more data coming into the system, a significant delay can be observed when accessing summary page.

Metadata

[https://github.com/UofS-Pulse-Binfo/rawphenotypes/issues/66]

[X] I feel this PR is ready to be merged.
[ ] This PR is dependent upon [PR #/ nothing]

Documentation:

[X] My code follows the code style of this project.
[ ] My change requires a change to the documentation.
[ ] I have updated the documentation accordingly.

Description

Summary page references a number of table to generate a summary of traits required by the heatmap. Each trait is then cross-checked for presence of value/data to ensure that it can be visualized. With the growing number of data and process involved to generate a summary, might cause the extended delays.

A table (materialized view) containing a summarized data of all raw phenotypes is available and by using this already summarized information, page load time significantly improved.

Dependencies

no dependencies.

Testing?

I compared page load time of summary page in portal versus KP clone and accessed projects available in either sites and compared the set of traits available for visualization. In both trials, page load time with this PR is faster than that in portal and traits appear to be the same.

Note: This PR now sorts the traits in alphabetical order.

[ ] I tested on a generic Tripal Site
[X] I tested on a KnowPulse Clone
[ ] This PR includes automated testing

laceysanderson commented 5 years ago

Also, tests need to pass before functional review.

reynoldtan commented 5 years ago

Revised query to speed up summary page. Back to you Lacey.

UofS-Pulse-Binfo / rawphenotypes