Performance Issue On Learning Environment Component With Large Amount Of Courses
Last updated on JUNE 21, 2017
Applies to:PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 and later
Information in this document applies to any platform.
On : 9.2 version, Other
Performance issue on Learning environment component with large amount of courses
In the LM_LE_CMP (Learning environment) component we encounter a performance issue. The LM_LE_REL_PG (Security) page contains 12k+ records in the Courses section. For each of these entries the PS_LM_CI_PT table is queried separately. This takes about 17-18 seconds, which is not acceptable for the client.
Should take less time.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms