Project

General

Profile

Actions

Idea #10213

open

Efficient queries for notification menu items

Added by Tom Morris over 7 years ago. Updated 2 months ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
-
Target version:
Start date:
Due date:
Story points:
-
Release:
Release relationship:
Auto

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

Actions

Also available in: Atom PDF