Uploadcsv email addr and username cache

Bug #1364229 reported by Nigel Cunningham
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
Medium
Unassigned

Bug Description

We can speed the validation of email addresses and usernames by doing a single query for each of usernames, email addresses and internal email addresses prior to entering the validation loop.

Test runs with 2000 preexisting users using XHProf showed a reduction in execution time from 6.5 seconds to 3.8 seconds, with an increase in memory use of approximately 1.3MB.

Changed in mahara:
status: New → Confirmed
importance: Undecided → Medium
Robert Lyon (robertl-9)
Changed in mahara:
status: Confirmed → Fix Committed
milestone: none → 15.04.0
Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/3611
Committed: http://gitorious.org/mahara/mahara/commit/e5a0f676901c36d489d8b7d8fde9f3c972ce1e48
Submitter: Robert Lyon (<email address hidden>)
Branch: master

commit e5a0f676901c36d489d8b7d8fde9f3c972ce1e48
Author: Nigel Cunningham <email address hidden>
Date: Mon Jul 28 12:03:08 2014 +1000

(Bug1364229) Upload CSV email addr and username cache optimisation.

This patch optimises the validation function by getting a list
of known email addresses and usernames prior to entering the
validation loop.

Test runs with 2000 preexisting users using XHProf showed a
reduction in execution time from 6.5 seconds to 3.8 seconds,
with an increase in memory use of approximately 1.3MB.

Change-Id: I099f1e3b7d459538b79b78afce271f582ec4a24c
Signed-off-by: Nigel Cunningham <email address hidden>

Robert Lyon (robertl-9)
Changed in mahara:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.