Primavera Data Warehouse leverages PL/SQL bulk operations to process smaller batches while performing interim commits. This results in linear scaling of update operations. For example, if it takes five minutes to update 1,000,000 rows, it will take ten minutes to update 2,000,000 rows). Rows per second performance remains constant regardless of amount of change or data size.
Many of the processes, including the PL/SQL bulk operation processes, are run in parallel threads. The use of parallel PL/SQL processes not only increases the potential scalability of this process, but also the demand for CPU powers and network bandwidth on the server.