Task #3646

Avatar?id=2560&size=50

Improve the performance of authentication operation in UPass

Added by Ahmadi Hadi almost 11 years ago. Updated almost 11 years ago.

Status:Work Completed-End life cycleStart date:September 30, 2013
Priority:HighDue date:
Assignee:Avatar?id=2560&size=14Ahmadi Hadi% Done:

90%

Category:-Spent time:-
Target version:-

Description

Currently our internal stress test of UPass shows considerably slow performance. Before thorough profiling, we have already identified the bottleneck, which is the communication with DB and probable network latency. I believe we can reduce this slowness by a factor of three, mainly by limiting the app-to-DB round-trips to only 1 round-trip during authentication.

respondingTimeGraph.png (47.6 KB) Ahmadi Hadi, October 05, 2013 23:55

History

#1 Avatar?id=2560&size=24 Updated by Ahmadi Hadi almost 11 years ago

  • Description updated (diff)

#2 Avatar?id=2560&size=24 Updated by Ahmadi Hadi almost 11 years ago

  • File respondingTimeGraph.png added
  • Status changed from Development / Work In Progress to Pending UAT Deployment
  • % Done changed from 10 to 90

The performance graph attached shows the performance improvement achieved by reducing DB-to-App round-trips, as well as adding crucial indices to DB.

#3 Updated by Tan Lee Yong almost 11 years ago

  • Status changed from Pending UAT Deployment to Work Completed-End life cycle

Also available in: Atom PDF