Bug #4523
Updated by Tom Clegg almost 10 years ago
To reproduce:
Go to https://workbench.qr1hi.arvadosapi.com/, enter any term into the search box (I used "hash") and click the search button. The search modal box will appear and display a spinning wheel. After some time it issues "Oops, request failed."
Proposed fix:
* Add database indexes to all tables, on
** each searchable column
** the full set of searchable columns (as returned by ModelClass.searchable_columns)
* To avoid undetected additions of columns without indexes in the future, add a unit test that iterates over all model classes and tests:
** each searchable column has an index
** there is an index on the full set of searchable columns