speed up RegionControl
What does this MR do?
requests to RegionControl especially to Germany take quite long. This MR reduces the amount of data which gets retrieved by the getRegionDetails()
Method on every call to a region page (forum,wall,fairteiler,members,events,statistics,applications)
for every single Request to a page in Germany, this reduces the load by
- ~100.000
file_exists
file system calls - 1 SQL Query with 46.913 rows response
- 1 SQL Query with 5.044 rows response
How confident are you it won't break things if deployed?
pretty
Links to related issues
Checklist
-
added a test, or explain why one is not needed/possible... -
no unrelated changes -
asked someone for a code review -
joined #foodsharing-beta channel at https://slackin.yunity.org -
added an entry to CHANGELOG.md (description, merge request link, username(s))
Edited by chandi