Thema / Theme

Objecten API

Omschrijving / Description

Currently at DH the search bar in the objects api is timing out when no object type has been selected as filter.
You cant always select an object type because this is unknown or will take extra time to figure out.

The ask is to improve objecten search in de admin UI so that operators have results quicker and no timeouts.

Could be connected to / picked up together with ticket: #615

TODO:

• Take time to analyze (max 1 day) what causes the slow queries, what could be possible fixes (and how long it would take to implement this). Make sure to test with a set of at least 1 million objectrecords
• Comment your findings + estimates in this issue for approval
• Implement suggestions from Better search capabilities / speed #621 (comment)

Toegevoegde waarde / Added value

No timeouts. Operators can do their work quicker.

Aanvullende opmerkingen / Additional context

This is solvable in multiple ways. It is up to the product team to see what is best. My thoughts:

• Make a separate search field for metadata (UUIDs, etc.) and object content
  • This is how the API already works with separate fields for metadata and dataAttr search
• Maybe improve indexing?
• Live loading of search results?
  • So at least partial answer comes back until the search times out

These are not requirements for a fix but ideas to investigate if they are worthy.