Story #10213

Efficient queries for notification menu items

Added by Tom Morris almost 3 years ago. Updated about 2 years ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
-
Target version:
Start date:
10/09/2016
Due date:
% Done:

0%

Estimated time:
Story points:
-

Description

One of the things the performance investigations of su92l turned up is that the queries used to determine the contents of the notification menu (e.g. has the user run a pipeline task yet?) are very expensive. While we want to improve the performance of the collection API, anything done this frequently should be super lightweight.

One possible solution would be to make this, and things like it, a flag on the user profile -- either a virtual flag computed at login time or an actual flag bit like is_active, is_admin, etc.

The results of the original investigation are here: https://dev.arvados.org/issues/10078#note-5

History

#1 Updated by Tom Morris about 2 years ago

  • Target version set to Arvados Future Sprints

Also available in: Atom PDF