Moodle

basic improvements eliminating some db queries

Details

  • Type: Improvement Improvement
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 1.9
  • Fix Version/s: 1.8.3, 1.9
  • Component/s: Database SQL/XMLDB
  • Labels:
    None
  • Affected Branches:
    MOODLE_19_STABLE
  • Fixed Branches:
    MOODLE_18_STABLE, MOODLE_19_STABLE

Description

working on some basic improvements that should lower db load when cache not used

Issue Links

This issue has a non-specific relationship to:
MDL-10635 function update_course_icon() does not scale Critical Closed

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Petr Škoda (skodak) added a comment -

these might be backported to 1.8.x quite easily

Show
Petr Škoda (skodak) added a comment - these might be backported to 1.8.x quite easily
Hide
Permalink
Petr Škoda (skodak) added a comment -

capability_search():

  • eliminated fetching of course - $COURSE used if id matches
  • parent category structure is cached in static array
Show
Petr Škoda (skodak) added a comment - capability_search():
  • eliminated fetching of course - $COURSE used if id matches
  • parent category structure is cached in static array
Hide
Permalink
Petr Škoda (skodak) added a comment -

implemented caching of course and category parents - eliminates substantial number of db queries - mostly during login and on course page

Show
Petr Škoda (skodak) added a comment - implemented caching of course and category parents - eliminates substantial number of db queries - mostly during login and on course page
Hide
Permalink
Petr Škoda (skodak) added a comment -

oh, btw there was a bug in get_parent_cats() when frontpage context submitted

Show
Petr Škoda (skodak) added a comment - oh, btw there was a bug in get_parent_cats() when frontpage context submitted
Hide
Permalink
Petr Škoda (skodak) added a comment -

patch in cvs HEAD

Show
Petr Škoda (skodak) added a comment - patch in cvs HEAD
Hide
Permalink
Petr Škoda (skodak) added a comment -

Partially backported into 1.8 branch too, closing now.
Most of this will be obsoleted by performance patches by ML.

Show
Petr Škoda (skodak) added a comment - Partially backported into 1.8 branch too, closing now. Most of this will be obsoleted by performance patches by ML.

People

Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.