Loading...

XML

Word

Printable

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

Affected Branches:
MOODLE_401_STABLE, MOODLE_402_STABLE, MOODLE_403_STABLE, MOODLE_404_STABLE, MOODLE_405_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 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]

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

_{More information about this report}

Built on: Mon Dec 16 07:38:49 PM UTC 2024
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 ] main (0 errors / 0 warnings) [branch: MDL-83991_master | CI Job ] More information about this report Built on: Mon Dec 16 07:38:49 PM UTC 2024

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:: Rohit Panchal, Santosh Nagargoje

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

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

Updated:: 20/Dec/24 2:09 AM

Details

Description

Attachments

Issue Links

Activity

People

Dates

Clockify