CSC/ECE 517 Spring 2015/oss E1510 FLP

From Expertiza_Wiki
Revision as of 01:34, 23 March 2015 by Fwu8 (talk | contribs)
Jump to navigation Jump to search

Expertiza - Fix Instructor Login Performance Issue

Expertiza is a web application where students can submit and peer-review learning objects (articles, code, web sites, etc). It is used in select courses at NC State and by professors at several other colleges and universities.<ref>Expertiza on GitHub</ref>

Project Description

Currently when an Instructor logs into Expertiza,there a lot of select* from assignments queries being fired on database which would have an adverse effect on performance. We analyzed the source of this issue and made some changes, which reduced the number of select queries executed. The performance is high improved. The mission involved is tracing the source of the issue and modify the code to fix the issue.

Performance issue before modification

Locate bug

Install query_reviewer

Analyze code

Modifications

_row_header.html.erb

_assignment_actions.html.erb

assignment_node.rb


Before Modification


After Modification

 

Performance Improvment

References

<references/>