Loading time optimization

Hello Forest community,

Yesterday our database got stuck because of huge queries from forest (so many join + query on all fields / relationship fields) and we are trying to figure it out and optimize database queries to reduce risks and day to day load time.

Have you some tips to help?

Feature(s) impacted

Edit Layout + advanced search

Observed behavior

  • Slow loading
  • Huge SQL requests consuming the database resources (different joins)
  • Searching all fields for a specific query

Expected behavior

  • Fast loading
  • optimized database requests
  • Allow advanced searches on specified fields

Failure Logs

Could not send data to client: Connection timed out

Context

  • Project name: JULAYA_DASHBOARD
  • Team name: Admin
  • Environment name: Production