A test just adding an index to resourcetype does help
However the uniqueness of a tag is based on the following fields
tag, resourcetype, resourceid, ownertype, ownerid
So we could add an index / unique index on those as a set
** Also affects: mahara/19.10
Importance: Undecided
Status: New
** Also affects: mahara/20.10
Importance: Undecided
Status: New
** Also affects: mahara/19.04
Importance: Undecided
Status: New
** Also affects: mahara/20.04
Importance: Undecided
Status: New
** Changed in: mahara/19.04
Milestone: None => 19.04.6
** Changed in: mahara/19.10
Milestone: None => 19.10.4
** Changed in: mahara/20.04
Milestone: None => 20.04.1
** Changed in: mahara/20.10
Milestone: None => 20.10.0
** Changed in: mahara/20.10
Importance: Undecided => High
** Changed in: mahara/20.04
Importance: Undecided => High
** Changed in: mahara/19.10
Importance: Undecided => High
** Changed in: mahara/19.04
Importance: Undecided => High
** Changed in: mahara/20.10
Status: New => Confirmed
** Changed in: mahara/20.04
Status: New => Confirmed
** Changed in: mahara/19.10
Status: New => Confirmed
** Changed in: mahara/19.04
Status: New => Confirmed
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask
on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1889340
Title:
Adding indexes to tag table to speed things up
Status in Mahara:
Confirmed
Status in Mahara 19.04 series:
Confirmed
Status in Mahara 19.10 series:
Confirmed
Status in Mahara 20.04 series:
Confirmed
Status in Mahara 20.10 series:
Confirmed
Bug description:
To make requests to tags table faster
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1889340/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
