Bug 102217

Summary: Student enrollment, class creation may be a performance hit
Product: [Retired] Red Hat Academy Reporter: Luke Meyer <lmeyer>
Component: Web ApplicationAssignee: Luke Meyer <lmeyer>
Status: CLOSED WONTFIX QA Contact: Bowe Strickland <bowe>
Severity: medium Docs Contact:
Priority: low    
Version: 9Keywords: FutureFeature
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2004-06-22 19:18:43 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Luke Meyer 2003-08-12 17:13:58 UTC 
When a student is enrolled, it takes several seconds of database activity.  This
can only get worse as the instance table grows.  At some point I need to talk
with Marty about how to make this more efficient.

Approximately the same issue is present with class enrollment.

One option is to do everything in perl (one big read, many sequential inserts).
 There may be other PL/SQL features available that help as well.  The challenge
is to avoid the thousands of reads and writes needed currently.
Comment 1 Luke Meyer 2004-06-22 19:18:43 UTC 
when this becomes a problem we'll worry about it.