Maybe find a simpler way someday to improve search performance, that doesn't require usage of extra views (if possible)

[Venryx]

Possible alternative approach: https://stackoverflow.com/a/75105382

Prior issue on the subject (where views were used to achieve the perf gains): https://github.com/debate-map/app/issues/301

[Venryx]

The optimization in the linked stackoverflow page (https://stackoverflow.com/a/75105382) was applied, and did help a lot. That said, having a view on top of that improved performance further (in some cases), so further investigation necessary to achieve max perf.