Improve Performance

[BacLuc]

Start improving the performance

• expand caching
• improve queries and other things (worker mode)

[BacLuc]

Configuration of the PHP Runtime

from: https://frankenphp.dev/docs/performance/

Number of Threads and Workers

• Increase number of threads #6612

Worker mode

(with other things, else it gets even worse)

• api: switch to worker mode #6598

Don't use musl

✔️ We already use the Debian Docker image

Go Runtime Configuration

• api_deployment.yaml: set GOMEMLIMIT variable #6606

Does not seem to have much of an effect with the value set now.
But it seems to improve the worker mode.

file_server

Placeholders

resolve_root_symlink

Removing unnecessary Requests from the frontend

• router.js do not load all entities, when Id is missing #6535

Optimize PHP Code

• RelatedCollectionLinkNormalizer performance improved #6536

Query optimization

Caching

[BacLuc]

I looked quickly if maybe the problem is outside of the query or serialization,
and it seems ingress-nginx and the api container have the same request duration. its not that the ingress-nginx is waiting for the api to pick up the request.

[manuelmeister]

Core Meeting Decision

• app.ecamp3.ch/api/activities?camp=%2Fapi%2Fcamps%2F{id}%2F
  p90: 2.045
  med: 0.981
  count: 25'841
  prevent embedding of content nodes of collection requests
  (subresources & cache & query optimization)
• app.ecamp3.ch/api/schedule_entries/{id}/
  p90: 1.908
  med: 0.162
  count: 17'118
  (investigate)
• app.ecamp3.ch/api/content_types?categories=%2Fapi%2Fcategories%2F{id}%2F
  p90: 3.311
  med: 0.891
  count: 2'231
  (remove query)
• app.ecamp3.ch/api/
  p90: 1.809
  med: 0.076
  count: 60'740
  (investigate)
• app.ecamp3.ch/api/camps/{id}/
  p90: 1.762
  med: 0.188
  count: 35'527
  (investigate)
• app.ecamp3.ch/api/content_node/material_nodes/{id}/
  p90: 1.523
  med: 0.544
  count: 15'277
  (investigate)
• app.ecamp3.ch/api/camp_collaborations?camp=%2Fapi%2Fcamps%2F{id}%2F
  p90: 0.791
  med: 0.365
  count: 11'134
  (subresources/cache/query opt.)
• app.ecamp3.ch/api/camp_collaborations/{id}/
  p90: 2.159
  med: 0.879
  count: 1'948
  (remove camp embedding?)
• app.ecamp3.ch/api/days/{id}/day_responsibles
  p90: 0.505
  med: 0.218
  count: 84'226
  (investigate)
• app.ecamp3.ch/api/activities/{id}/
  p90: 0.491
  med: 0.222
  count: 105'506
  (improve/investigate)