Mahara

Performance improvement for view_search() when finding copyable views

Bug #1527031 reported by Robert Lyon
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
Medium
Robert Lyon
Mahara 16.10.0
16.04
Fix Released
Medium
Robert Lyon
Mahara 16.04.3

Bug Description

Adjusting the sql from using IN() to use EXISTS()

Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "master" branch: https://reviews.mahara.org/5857

Robert Lyon (robertl-9)
Changed in mahara:
importance: Undecided → Medium
status: New → In Progress
assignee: nobody → Robert Lyon (robertl-9)
milestone: none → 16.04.0
Kristina Hoeppner (kris-hoeppner)
summary: - Performance implovement for view_search() when finding copyable views
+ Performance improvement for view_search() when finding copyable views
Aaron Wells (u-aaronw)
Changed in mahara:
milestone: 16.04.0 → 16.10.0
Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/5857
Committed: https://git.mahara.org/mahara/mahara/commit/f53afd689e79bc0efb6ccc73e29b0e390a743512
Submitter: Son Nguyen (<email address hidden>)
Branch: master

commit f53afd689e79bc0efb6ccc73e29b0e390a743512
Author: Aaron Wells <email address hidden>
Date: Thu Dec 17 16:05:15 2015 +1300

Bug 1527031: Adjusting the view_search() for finding editable views

Improving speed of sql query by using 'EXISTS' to check against group
views

behatnotneeded

Change-Id: I0546092c5715a582ad6079f875aeac54a9dd0255
Signed-off-by: Robert Lyon <email address hidden>

Aaron Wells (u-aaronw)
Changed in mahara:
status: In Progress → Fix Committed
Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "16.04_STABLE" branch: https://reviews.mahara.org/6784

Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/6784
Committed: https://git.mahara.org/mahara/mahara/commit/2f925bdcfe3e68d8e4a63ed9862d45fe09d2f7c7
Submitter: Robert Lyon (<email address hidden>)
Branch: 16.04_STABLE

commit 2f925bdcfe3e68d8e4a63ed9862d45fe09d2f7c7
Author: Aaron Wells <email address hidden>
Date: Thu Dec 17 16:05:15 2015 +1300

Bug 1527031: Adjusting the view_search() for finding editable views

Improving speed of sql query by using 'EXISTS' to check against group
views

behatnotneeded

Change-Id: I0546092c5715a582ad6079f875aeac54a9dd0255
Signed-off-by: Robert Lyon <email address hidden>
(cherry picked from commit f53afd689e79bc0efb6ccc73e29b0e390a743512)

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.
Subscribing...

Other bug subscribers

Remote bug watches

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