[#MDL-12594] Restoring a course with 400 users enrolled costs 13k DB queries

Issue Details (XML | Word | Printable)

Key:	MDL-12594
Type:	Bug
Status:	Closed
Resolution:	Fixed
Priority:	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:

backup-cf101-20080121-1619.zip (74 kB)
2.

restorelib.php (393 kB)

Issue Links:

Dependency

This issue will be resolved by:

MDL-14269 META: Backup performance

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.