mahara-contributors team mailing list archive

[Robert Lyon <1889340@xxxxxxxxxxxxxxxxxx>]

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