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
    In Progress
  • Priority
    Medium
  • Type
    Programming work
  • Assigned to
    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.