Replace the shortcut_set_users table with a base field on users

Created on 6 April 2024, 9 months ago
Updated 17 April 2024, 8 months ago

Problem/Motivation

Shortcut module users a database table to store user shortcut sets:

MariaDB [db]> DESCRIBE shortcut_set_users;
+----------+------------------+------+-----+---------+-------+
| Field    | Type             | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| uid      | int(10) unsigned | NO   | PRI | 0       |       |
| set_name | varchar(32)      | NO   | MUL |         |       |
+----------+------------------+------+-----+---------+-------+
2 rows in set (0.003 sec)

this means separate database queries to lookup the shortcut set for a user. It could be a base field on users, then it wouldn't require the extra query.

Found via ✨ Provide a new user.shortcut_set cache context Needs work .

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet

πŸ“Œ Task
Status

Active

Version

11.0 πŸ”₯

Component
ShortcutΒ  β†’

Last updated 3 months ago

  • Maintained by
  • πŸ‡¨πŸ‡¦Canada @jibran
Created by

πŸ‡¬πŸ‡§United Kingdom catch

Live updates comments and jobs are added and updated live.
  • Performance

    It affects performance. It is often combined with the Needs profiling tag.

Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024