Public bug reported:
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.
** Affects: mahara
Importance: Undecided
Status: New
** Tags: and collections description optimization pages search tags title
--
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:
Mahara19 page tag search optimization
Status in Mahara:
New
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 : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
