** Changed in: mahara
Milestone: 20.10.0 => None
--
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 edit
** Changed in: mahara/19.10
Status: Fix Committed => Fix Released
--
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.o
** Changed in: mahara/20.04
Status: Fix Committed => Fix Released
--
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.o
** Changed in: mahara/19.04
Status: Fix Committed => Fix Released
--
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.o
** Changed in: mahara/20.10
Status: Fix Committed => Fix Released
--
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.o
** Changed in: mahara/19.04
Status: Confirmed => Fix Committed
--
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
** Changed in: mahara/19.10
Status: Confirmed => Fix Committed
--
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
** Changed in: mahara/20.04
Status: Confirmed => Fix Committed
--
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
** Changed in: mahara/20.10
Status: In Progress => Fix Committed
--
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.or
** Changed in: mahara/20.10
Status: Confirmed => In Progress
--
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 fo
** Changed in: mahara/19.04
Milestone: 19.04.6 => 19.04.7
** Changed in: mahara/19.10
Milestone: 19.10.4 => 19.10.5
** Changed in: mahara/20.04
Milestone: 20.04.1 => 20.04.2
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to
To test:
Go to a big site and find a view with some tags on it - make a note of
the view id and plug that into the SQL above in place of the '123'
Run that 'explain ...' sql and make a note of the "Planning time" and
"Execution time" - run it a few time to get an average
Then add the unique ind
** Changed in: mahara/20.10
Assignee: (unassigned) => Robert Lyon (robertl-9)
--
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 o
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
Statu
To analyze do something like this:
explain analyze SELECT a.title, p.title AS parenttitle, a.id, a.parent,
a.owner, a.author, a.authorname,
a.description, a.allowcomments, at.tag, a.ctime, a.mtime
FROM "artefact" a
JOIN "artefact" p ON a.parent
15 matches
Mail list logo