Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Won't Fix
-
Affects Version/s: 1.9
-
Fix Version/s: None
-
Component/s: Database SQL/XMLDB, Lesson, Performance
-
Labels:None
-
Environment:MySQL
Etch
apache2
-
Database:MySQL
-
Affected Branches:MOODLE_19_STABLE
Description
During a lesson, each time the user presses F5 or refreshes the page, a new record is created in the table mdl_lesson_attempts with unused identical data (apart of the submission time), and even worse everytime a user gets back with the browser she can forge a new answer that get recorder as well. Fortunately the program takes care only for the first of these rows!
I have evaluating the set up of a moodle environment for more than 110.000 users (should be more than 300.000 in a couple of years) and about 300 lessons of 10 pages each (plus forums, etc), it is easy to understand that it will be more than frequent that I will have to deal with millions of spurious records!
I suggest to make a simple check to assure the record is really needed before adding it to the table!
Assigning this to Mark (sorry by the delay).
Seems that something could be used to avoid duplicates (or to clean them).
But I don't know too much about lesson internals. For sure Mark does!
Ciao