Project

General

Profile

Bug #4523

Updated by Tom Clegg over 9 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: tables, on 
 ** one on owner_uuid each searchable column 
 ** one on the full set of searchable columns (as returned by ModelClass.searchable_columns) 
 ** (phase2) each searchable column 
 * 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 a multi-column an index on the full set of searchable columns 
 ** there is an index on owner_uuid and an index on uuid 
 ** (phase2) there is an index each searchable column 

 Let's wait on the "(phase2)" items until we see results from the rest... 

Back