[MDL-75688] Add courseid,bigbluebuttonid as index to the bigbluebuttonbn_logs table - Moodle Tracker

XML

Word

Printable

Details

Type: Improvement
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: 4.1, 4.2
Fix Version/s: 4.2
Component/s: BigBlueButton
Labels:
- ci
- triaged

Affected Branches:
MOODLE_401_STABLE, MOODLE_402_STABLE
Fixed Branches:
MOODLE_402_STABLE
Epic Link:
BigBlueButton New Features and Improvements for 4.2
Pull from Repository:
https://github.com/call-learning/moodle
Pull Master Branch:
~~MDL-75688~~-master
Pull Master Diff URL:
https://github.com/moodle/moodle/compare/master...call-learning:moodle:MDL-75688-master
Testing Instructions:
1. Upgrade the module
2. Ensure that there is no error when upgrading the BigBlueButton module
3. Test the module using PHP Unit
4. Ensure that there is no error

Description

Following up from ~~MDL-75227~~ issue we noticed that the bigbluebuttonbn_logs table should declare (courseid and bigbluebuttonbnid) as compound index to accelerate the queries.

Attachments

Issue Links

has to be done after

MDL-75227 BigBlueButton activities causes course page load times to increase linearly

Closed

Testing discovered

MDL-76950 Remove log index in bigbluebuttonbn_logs table

Open

Activity

People

Assignee:: Laurent DAVID

Reporter:: Laurent DAVID

Peer reviewer:: Shamiso Jaravaza

Integrator:: Ferran Recio

Tester:: CiBoT

Participants:: Andrew Lyons, CiBoT, Ferran Recio, Laurent DAVID, Shamiso Jaravaza

Component watchers:: Jesus Federico, Laurent DAVID, Amaia Anabitarte, Carlos Escobedo, Laurent David, Mikel Martín Corrales, Sabina Abellan, Sara Arjona (@sarjona)

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 07/Sep/22 11:36 PM

Updated:: 10/Feb/23 11:19 PM

Resolved:: 10/Feb/23 11:19 PM

Fix Release Date:: 24/Apr/23

Time Tracking

Estimated:

Remaining:

Logged:

2h 41m