search

academic-moodle-cooperation / moodle-mod_publication

Online texts and files can be collected and published via the Student Folder activity and thus made available to everyone in a Moodle course. Submissions can be made directly by uploading or alternatively can be taken over by teachers from an assignment activity.
https://academic-moodle-cooperation.org/mod_publication/
12 stars 21 forks source link

mod/publication/view.php is loading very slowly due to missing index #47

Closed rub-moodle-its closed 3 years ago

rub-moodle-its commented 3 years ago

In a course with more than 700 students the overview page mod/publication/view.php is loading very slowly due to a missing index.

Please add an index on column "publication" for table "publication_files" to speed things up.

goggo24 commented 3 years ago

Thanks for your feedback. We have planned it for the next version.

goggo24 commented 3 years ago

Index is included in v.3.11.0 - coming this weekend.