I'm in a POC that need to load around 40B rows of sales transaction records, because of the volume of data, the performance is not good. I'm trying to split into 2 QVWs, one is for monthly aggregated result and another one is for transaction analysis. My question is if I had made several selection in Monthly Aggregated QVW and pass those parameter to the transnational QVW, will it speed up the loading time and also will it reduce the use of RAM for the transnational QVW (Currently it used around 40GB of RAM and takes around 5 minutes to open the report)?
by splitting in to two separate QVW's yes you will improve the performance of the monthly aggregated version, if you leave the transaction application as is though, it will still need to be opened when document chaining and take the 5 minute load time.
If you split down the transactional QVW into a number of different period QVW's and loaded whichever one was relevant for your selections you would get the application opening faster.
i.e have your transactional QVW split into a quarter by quarter application.
