Issue Details (XML | Word | Printable)

Key: MDL-12594
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Eloy Lafuente (stronk7)
Reporter: Dan Poltawski
Votes: 3
Watchers: 3
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

Restoring a course with 400 users enrolled costs 13k DB queries

Created: 16/Dec/07 09:15 AM   Updated: 13/May/08 04:48 PM
Return to search
Component/s: Backup
Affects Version/s: 1.9
Fix Version/s: 1.9.1

File Attachments: 1. Zip Archive backup-cf101-20080121-1619.zip (74 kB)
2. File restorelib.php (393 kB)
Issue Links:
Dependency
 

Participants: Dan Poltawski, Eloy Lafuente (stronk7), Pat B. and Petr Skoda
Security Level: None
QA Assignee: Petr Skoda
Resolved date: 13/May/08
Affected Branches: MOODLE_19_STABLE
Fixed Branches: MOODLE_19_STABLE


 Description  « Hide
Ouch, was just playing with a course with 400 users and restoring it cost 13k db queries!

I quickly put a few mtraces in restore_create_users with $PERF->dbqueries and it seems to cost about 6000 queries on itself to end up not doing much.

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Dan Poltawski made changes - 22/Jan/08 01:24 AM
Field Original Value New Value
Attachment backup-cf101-20080121-1619.zip [ 12920 ]
Pat B. made changes - 28/Jan/08 11:45 PM
Attachment restorelib.php [ 12963 ]
Dan Marsden made changes - 09/Apr/08 06:45 AM
Link This issue will be resolved by MDL-14269 [ MDL-14269 ]
Martin Dougiamas made changes - 21/Apr/08 03:10 PM
Assignee Martin Dougiamas [ dougiamas ] Eloy Lafuente (stronk7) [ stronk7 ]
Eloy Lafuente (stronk7) made changes - 13/May/08 02:02 AM
Fix Version/s 1.9.1 [ 10240 ]
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Petr Skoda made changes - 13/May/08 04:48 PM
Status Resolved [ 5 ] Closed [ 6 ]
QA Assignee skodak

Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.
Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.5-#360) - Bug/feature request - Atlassian news - Contact Administrators