List of issues, missing features and possible optimizations for new cross-search

[juhanikat]

Here are some things that have been left out of the server side pagination for cross-search:

Issues:

• DetailBrowser (the top bar in a detail view that allows viewing the next or previous item) doesn't work properly with cross-search, you can use it to go backwards but not forwards. This likely has something to do with the fact that cross-search has multiple rows with the same locality. It also shows "X of 50" even though cross-search has thousands of rows.

Missing features:

• Fuzzy search might be a good feature to have at some point (some version of this should be moderately easy to implement using SQL LIKE operator)
• "Submit" button or something similar, that the user can press to submit their current column filters once they have finished typing. This is to avoid needless fetching of data.
• Maybe the user should be shown how many rows of data the table has in total?

Possible optimizations:

• The SQL query could be changed to not select fields that have been hidden in the table view.
• Redux supports "infinite queries", maybe these could be used instead of normal queries to continue loading more pages in the background? https://redux-toolkit.js.org/rtk-query/usage/infinite-queries
• Memoization could likely be used somewhere inside the CrossSearchTable or TableView files to improve performance: https://www.material-react-table.com/docs/guides/memoization