Adding "link to table" field value calls API search with a lookup field with all the available values
Describe the problem
Opening an option modal is extremely slow due to fetching list of options with all the look up values
Steps to reproduce
We have a table of ~50k rows and a few linked tables of 50-100 rows. Each row from the main table has one value from each of the linked tables. Linked tables have a lookup field added automatically by the Baserow that makes a backward lookup. We also have a count field to count number of times the record was linked to main.
Now, every time a user clicks on a field to add a new linked value, a modal appears with options and an API call is made to fetch them. API call is /api/database/rows/table/566/?page=1&size=10
. In our case each of such calls fetches 10 options (1 page of options) but with ~10k lookup values which results in ~1.5-2mb data per request.
Actual result
Options modal fetches all lookup fields which is slow
Expected result
Ignore automatically created lookup field and only meaningful fields (or to have an option to only return one field for an option modal)
Environment
1.22.3, self-hosted with docker compose Ubuntu Server