Group Security Dashboard `vulnerabilities` endpoint is timing out

When working, Group Security Dashboard history endpoint timing out , it was discovered that the vulnerabilities endpoint is slow and times out. This is affecting adoption/usage of the Group Security dashboard.

In #11693 (closed), we added caching to speed up the history endpoint. A different approach will need to be taken to address this problem.

Also note that we're heading towards First-class vulnerabilities, which may also solve this problem.

Over the past 4 months, we've seen the following timeouts (as of 6/13/2019):

vulnerabilities/index - 32 occurrences

Proposal

To address slowness in the history endpoint, we added caching (see above in the description for more info), but we will need to find a different approach to solve this as that caching is not possible with the pagination we use for this endpoint.

• Determine if the changes for First-class vulnerabilities give us any new ways to solve this problem
• Failing that, brainstorm if there any other ways to bring back these vulnerabilities in a more performant way
• Failing that, analyze the sql statements (included in #11693 (closed)) and see if they can be re-written or if an index could be added to speed things up.