You have many different configuration options you can deploy to accommodate your environment. The configuration that works best will depend on the data size, data requirements, environment, and servers available.
The data flow from P6 can affect your Primavera Data Warehouse.