Meta: :chart_with_downwards_trend: API performance

digitalfabrik / integreat-cms

Simplified content management back end for the Integreat App - a multilingual information platform for newcomers

https://digitalfabrik.github.io/integreat-cms/

Apache License 2.0

56 stars 35 forks source link

Meta: :chart_with_downwards_trend: API performance #2236

Open svenseeberg opened 1 year ago

svenseeberg commented 1 year ago

Motivation

The Integreat App currently has long loading times according to the Google Search console. We should improve loading times were we can by reducing API response latency where possible. There is a corresponding Epic in the App issue tracker.

[x] #2169
[x] Cache sites endpoint
[ ] #2167
[ ] #2204

timobrembeck commented 1 year ago

Apart from the listed issues, we could also revisit all API endpoints and optimize our SQL queries and Python calculations. I'm pretty sure the views have quite some potential for improvement.

Also, is there a JIRA issue about the app-side of things that could be linked here? The changes in #2167 are very complex, so it might be easier to refactor some stuff in the app and provide simpler api endpoints that don't deliver unnecessary data.