forms icon indicating copy to clipboard operation
forms copied to clipboard

Process forms in chunks or use pagination

Open susnux opened this issue 1 year ago • 4 comments

This is more of a meta issue.

Currently for a lot of operations we query all (forms, submissions...) but for large instances this might get a problem if there are e.g. 30'000 forms or 3'000 submissions.

We should figure out a good way to handle:

  • [ ] Show form results (fetching the results might be bad if there are hundreds or thousands of submissions)
  • [ ] Investigate if there are more places that are problematic

susnux avatar Mar 22 '24 11:03 susnux

findAll() in FormsMapper is only used for shared forms. So I think that we could already filter the following forms:

  • showToAllUsers in access_json is true in forms table
  • rows in shares table for form_id and share_with = current user

Chartman123 avatar Mar 23 '24 11:03 Chartman123