My Oracle Support Banner

Slow Drawing and Scrolling of Project View in P6 Professional (Doc ID 2256988.1)

Last updated on MAY 05, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version and later
Primavera P6 Professional Project Management - Version 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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.