Metabolite explorer page slow

[kmcluskey]

The Metabolite explorer page is really slow to load on the server - not sure why but think some caching should be added.

[joewandy]

The default cache timeout for the view is 60 * 18000 = 12.5 days. If the view hasn't been accessed after 12 days, the data needs to be refetched again. Maybe that's why it's slow if the app hasn't been accessed in a while? I just tried loading the Metabolite explorer page. First it's slow but second time it's fast again.

Also looking at the metabolite_data view, it seems like it should be possible to retrieve Compound objects and all their related CompoundDBDetails all at once? Right now it's looping over each compound and retrieving the related details for each compound, generating a lot of SQLs each time. https://github.com/kmcluskey/FlyMet/blob/master/met_explore/views.py#L154-L163. If we rewrite this part, it should massively speed things up.