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

None
4 years, 5 months ago

New task was created

Paul Hoekman Paul Hoekman Johannesburg 2140 points
4 years, 5 months ago

Task was assigned to Paul Hoekman

Paul Hoekman Paul Hoekman Johannesburg 2140 points
4 years, 5 months ago

Status change: Open → In Progress

Paul Hoekman Paul Hoekman Johannesburg 2140 points
4 years, 5 months ago

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.

Paul Hoekman Paul Hoekman Johannesburg 2140 points
1 year, 1 month ago

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 Paul Hoekman Johannesburg 2140 points
1 year, 1 month ago

Paul Hoekman is no longer responsible for this task