Community Portal

Speed up case studies page

Created on Tuesday 9 June 2020, 14:11

Back to task list
  • ID
    18980
  • Project
    Metabolism of Cities Library
  • Status
    Open
  • Priority
    Medium
  • Type
    Programming work
  • Assigned to
    No one yet
  • Subscribers
    Paul Hoekman

You are not logged in

Log In Register

Please join us and let's build things, together!

Description

This page opens slowly; likely due to the double looping over locations and methods. We can likely speed things up by prefetching these secondary relations.

Discussion and updates


New task was created


Task was assigned to Paul Hoekman


Status change: Open → In Progress


It seems like caching this page is the way to go. There are just too many SQL queries that we have to run, because tags and spaces are pulled in for every record. Prefetching doesn't do the trick, because it goes multiple levels deep. Explored caching a bit, this should really solve it. Must install on the server first and then get it going for both the table and the map.


Caching system was set up at some stage and can be used for this. I am stepping down from MoC but any volunteer who wants to liaise about this feel free to get in touch.


Paul Hoekman is no longer responsible for this task