Red Hat Bugzilla – Bug 102217
Student enrollment, class creation may be a performance hit
Last modified: 2007-03-27 00:08:56 EDT
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.
when this becomes a problem we'll worry about it.