Bug 102217 - Student enrollment, class creation may be a performance hit
Summary: Student enrollment, class creation may be a performance hit
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: Red Hat Academy
Classification: Retired
Component: Web Application
Version: 9
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
Assignee: Luke Meyer
QA Contact: Bowe Strickland
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2003-08-12 17:13 UTC by Luke Meyer
Modified: 2007-03-27 04:08 UTC (History)
0 users

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed: 2004-06-22 19:18:43 UTC
Embargoed:


Attachments (Terms of Use)

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.


Note You need to log in before you can comment on or make changes to this bug.