I have a website with a slow page load mainly due to a slow query on a listing. I think there might be a better way to query the data / arrange the data back end which is what's causing the query to be slow.
So the data is like this
Area -> Level -> Path, the path then links to a pool of units included within that path.
The units then have study locations listed as child pages for that unit with contact information etc.
I have a page where i list all the study locations, but because i'm going through every unit and then every child study location page it takes quite a while.
I have over 200 units with around 5 locations as sub pages.
Any way i can reorganise the data to make this listing faster to load?