Loading...

XML

Word

Printable

Type: Bug
Resolution: Unresolved
Priority: Critical
Fix Version/s: None
Affects Version/s: 4.2.11, 4.1.16, 4.3.10, 4.4.6, 4.5.2, 5.0
Component/s: Tags
Labels:

Affected Branches:
MOODLE_401_STABLE, MOODLE_402_STABLE, MOODLE_403_STABLE, MOODLE_404_STABLE, MOODLE_405_STABLE, MOODLE_500_STABLE
Pull from Repository:
https://github.com/panchalrohit/moodle
Pull 4.4 Branch:
MDL-83991_404
Pull 4.4 Diff URL:
https://github.com/moodle/moodle/compare/MOODLE_404_STABLE...panchalrohit:moodle:MDL-83991_404
Pull 4.5 Branch:
MDL-83991_405
Pull 4.5 Diff URL:
https://github.com/moodle/moodle/compare/MOODLE_405_STABLE...panchalrohit:moodle:MDL-83991_405
Pull 5.0 Branch:
MDL-83991_500
Pull 5.0 Diff URL:
https://github.com/moodle/moodle/compare/MOODLE_500_STABLE...panchalrohit:moodle:MDL-83991_500
Pull Main Branch:
MDL-83991_master
Pull Main Diff URL:
https://github.com/moodle/moodle/compare/main...panchalrohit:moodle:MDL-83991_master
Testing Instructions:
Hide

Login with Admin/ Instructor

Create Course.

Create question bank and add large number of questions and map them with tags.

once you have done with above steps.

Click on more tab in Navbar, select question bank from dropdown.

Ensure question bank loads successfully.
Show
Login with Admin/ Instructor Create Course. Create question bank and add large number of questions and map them with tags. once you have done with above steps. Click on more tab in Navbar, select question bank from dropdown. Ensure question bank loads successfully.
Pre-check results:
Hide

Code verified against automated checks.

Checked MDL-83991 using repository: https://github.com/panchalrohit/moodle

MOODLE_404_STABLE (0 errors / 0 warnings) [branch: MDL-83991_404 | CI Job]

MOODLE_405_STABLE (0 errors / 0 warnings) [branch: MDL-83991_405 | CI Job]

MOODLE_500_STABLE (0 errors / 0 warnings) [branch: MDL-83991_500 | CI Job]

main (0 errors / 0 warnings) [branch: MDL-83991_master | CI Job]

_{More information about this report}

Built on: Sat May 3 11:49:03 UTC 2025
Show
Code verified against automated checks. Checked MDL-83991 using repository: https://github.com/panchalrohit/moodle MOODLE_404_STABLE (0 errors / 0 warnings) [branch: MDL-83991_404 | CI Job ] MOODLE_405_STABLE (0 errors / 0 warnings) [branch: MDL-83991_405 | CI Job ] MOODLE_500_STABLE (0 errors / 0 warnings) [branch: MDL-83991_500 | CI Job ] main (0 errors / 0 warnings) [branch: MDL-83991_master | CI Job ] More information about this report Built on: Sat May 3 11:49:03 UTC 2025
Automated test results:
Hide

Launching automatic jobs for branch MDL-83991_404

https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/18027/ PHPUnit (sqlsrv)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61606/ Behat (NonJS - boost and classic)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61607/ Behat (Firefox - boost)

Launching automatic jobs for branch MDL-83991_405

https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/18028/ PHPUnit (sqlsrv)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61608/ Behat (NonJS - boost and classic)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61609/ Behat (Firefox - boost)

Launching automatic jobs for branch MDL-83991_master

https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/18029/ PHPUnit (sqlsrv)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61612/ Behat (NonJS - boost and classic)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61613/ Behat (Firefox - boost)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61614/ Behat (Firefox - classic)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61615/ App tests (stable app version) --> unrelated app failures

Built on: Wed Jan 22 10:21:45 AM UTC 2025
Show
Launching automatic jobs for branch MDL-83991 _404 https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/18027/ PHPUnit (sqlsrv) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61606/ Behat (NonJS - boost and classic) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61607/ Behat (Firefox - boost) Launching automatic jobs for branch MDL-83991 _405 https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/18028/ PHPUnit (sqlsrv) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61608/ Behat (NonJS - boost and classic) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61609/ Behat (Firefox - boost) Launching automatic jobs for branch MDL-83991 _master https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/18029/ PHPUnit (sqlsrv) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61612/ Behat (NonJS - boost and classic) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61613/ Behat (Firefox - boost) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61614/ Behat (Firefox - classic) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/61615/ App tests (stable app version) --> unrelated app failures Built on: Wed Jan 22 10:21:45 AM UTC 2025

Sprint:
Hhogs Merge Review Candidates

It has been observed that the tag related SQL queries from get_tags_by_area_in_context() of /tag/classes/tag.php are running very slow due to large amount of data in tag_instance table.

It's taking around 12-15 minutes to fetch data when there are 240594719 records in tag_instance table.

has been marked as being related by

MDL-61435 Improve performance of get_tags_by_area_in_contexts SQL query

Closed

Assignee:: Unassigned

Reporter:: Santosh Nagargoje

Peer reviewer:: Santosh Nagargoje

Participants:: CiBoT, Jun Pataleta, Mihail Geshoski, Rohit Panchal, Santosh Nagargoje

Votes:: 1 Vote for this issue

Watchers:: 5 Start watching this issue

Created:: 12/Dec/24 4:07 AM

Updated:: 13/Jun/25 4:49 PM

Estimated:

Remaining:

Logged:

Details

Description

Attachments

Issue Links

Activity

People

Dates

Time Tracking

Clockify