Primavera Analytics supports immediate project ETL for a selected set of P6 projects, while in the database, PROJECT.ETL_INTERVAL=0. Any updates to tables that belong to these projects, such as, Activity, Resource Assignment, etc., triggers the immediate ETL. Due to the duration of ETL, usually a few minutes for an update, ensure that a minimal set of projects are selected. Otherwise, the performance of immediate ETL will deteriorate.
For commodity hardware, select a maximum of 10 projects. The number of projects depends on the activity and resource assignment spread rows.
As a P6 database user, run the following query which returns the number of spread rows for projects enabled immediate ETL in P6 database:
select sum(total_rows) from (
select count(*) total_rows from activityspread where projectobjectid in (select proj_id from project where etl_interval = 0 and project_flag='Y' and px_enable_publication_flag='Y' and orig_proj_id is null)
union
select count(*) total_rows from resourceassignmentspread where projectobjectid in (select proj_id from project where etl_interval = 0 and project_flag='Y' and px_enable_publication_flag='Y' and orig_proj_id is null)
);
It is recommended that the number of rows should be approximately 10,000.