"Graphical Filtering on Phenotype Performance" tool performance and bugs

[dwaring87]

Expected Behavior

The "Graphical Filtering on Phenotype Performance" tool on the /search/stocks page has performance issues and a bug that don't really make it useful for most use cases.

The BrAPI request to /observationunits takes far too long (to the point where it seems like it's not working) and once it finishes the drop down menu to select a trait is empty.

Example:

1. Go to the Search > Stocks page on T3/Oat (https://oat.triticeaetoolbox.org/search/stocks)
2. Limit the number of accessions to search by filtering by a single trait:
   • Expand Advanced Search
   • Expand Phenotypes
   • Enter Groat oil content - percent in the Trait field
   • Search
   • This returns ~6400 accessions
3. Expand the "Graphical Filtering on Phenotype Performance" section and the "Graphical Filter Accessions by Traits" subsection
   • The request to /observationunits takes about 36 minutes to complete
4. Try to select a trait in the query builder and there is nothing listed in the drop down menu

For Bugs:

Environment

Steps to Reproduce