*** This bug is a duplicate of bug 1889340 ***
https://bugs.launchpad.net/bugs/1889340
** This bug has been marked a duplicate of bug 1889340
Adding indexes to tag table to speed things up
--
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/1857010
Title:
Mahara page tag search optimization
Status in Mahara:
Incomplete
Bug description:
Mahara Version: 19.04.3
DB Version: MySQL 5.1
Reporting: Optimization
Issue:
The search function '(Title, description, tags)' on the 'pages and
collections' page is slow when there are large numbers of tags and if that user
has many pages/collections.
This is not an issue with version: Mahara 18.04.5
Details:
For Mahara 19.04.3 I have 166,618 entries in the 'mah_tag' table and my user
has 200 pages.
When doing a search with (Title, description, tags) selected it takes about
15 seconds for the search.
For Mahara 18.04.5 I have 139,877 entries in the 'mah_view_tag' table and my
user has 200 pages.
When doing a search with (Title, description, tags) selected it takes less
than a second for the search.
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1857010/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
