Last updated on MAY 05, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 188.8.131.52 and later
Primavera P6 Professional Project Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
After the project view data is loaded, when the projects grid is first displayed, there is a database query executed for each and every displayed row.
If you scroll down to display more rows, the new rows continue to invoke database calls. The SQL query indicates it's getting the project open/locked status for each row.
This only happens for direct db connection (not cloud connect).
Once you scroll through the entire view, it will stop querying the database.
But, if you change the grouping, it will start querying all over again.
This becomes noticeable when database latency is around 5ms, the drawing becomes sluggish.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms