Skip to content

speed up RegionControl

chandi requested to merge region-speedup into master

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

Merge request reports