mahara-contributors team mailing list archive

[Kevin Hipwell <1857010@xxxxxxxxxxxxxxxxxx>]

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