Moodle

Save some bits in the cron execution...

Details

  • Type: Improvement Improvement
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 1.9
  • Fix Version/s: 1.9
  • Component/s: Administration
  • Labels:
    None
  • Database:
    Any
  • Affected Branches:
    MOODLE_19_STABLE
  • Fixed Branches:
    MOODLE_19_STABLE

Description

I've been monitorizing one big server with a lot of users... and there are 2 functions, exclusively used by the cron execution that can be improved easily. They are:

get_users_unconfirmed()
get_users_not_fully_set_up()

Both return all the fields from the user table, whereas only a few are needed. Reducing will save some DB & traffic extra work.

Ciao

Issue Links

Activity

Hide
Eloy Lafuente (stronk7) added a comment -
  • Move both functions to deprecatedlib.php (marked for deletion for 2.0)
  • Re-implement as direct recordset in admin/cron.php
Show
Eloy Lafuente (stronk7) added a comment -
  • Move both functions to deprecatedlib.php (marked for deletion for 2.0)
  • Re-implement as direct recordset in admin/cron.php
Hide
Eloy Lafuente (stronk7) added a comment -

implemented (tested only in my small test environment, seems to work)

Show
Eloy Lafuente (stronk7) added a comment - implemented (tested only in my small test environment, seems to work)

People

Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: