Loading...

XML

Word

Printable

Type: Improvement
Resolution: Fixed
Priority: Minor
Fix Version/s: 2.1.2
Affects Version/s: 2.0.3, 2.1
Component/s: Database SQL/XMLDB
Labels:
- triaged

Affected Branches:
MOODLE_20_STABLE, MOODLE_21_STABLE
Fixed Branches:
MOODLE_21_STABLE
Pull from Repository:
git://github.com/skodak/moodle.git
Pull Main Branch:
w31_~~MDL-28533~~_m22_columnperf
Pull Main Diff URL:
https://github.com/skodak/moodle/compare/master...w31_MDL-28533_m22_columnperf
Testing Instructions:

Hide

1/ enable perf info in page footer
2/ compare queries per page with and without debugging enabled/disabled

Expected result is 5-15 fewer read queries in most pages.

Show
1/ enable perf info in page footer 2/ compare queries per page with and without debugging enabled/disabled Expected result is 5-15 fewer read queries in most pages.

The problem is that the current moodle_database->where_clase() does one extra DB query to fetch table columns. This is useful for developers only, for performance reasons it should be disabled on production sites...

has a non-specific relationship to

MDL-24863 MS SQL DB driver casting string to int breaks a query that should work, which breaks qtype_multichoice upgrade

Closed

Assignee:: Petr Skoda

Reporter:: Petr Skoda

Integrator:: Eloy Lafuente (stronk7)

Tester:: Eloy Lafuente (stronk7)

Participants:: Eloy Lafuente (stronk7), Petr Skoda, Tim Hunt

Votes:: 2 Vote for this issue

Watchers:: 3 Start watching this issue

Created:: 30/Jul/11 12:27 AM

Updated:: 12/Aug/11 5:04 PM

Resolved:: 12/Aug/11 5:04 PM

Details

Description

Attachments

Issue Links

Activity

People

Dates

Clockify