Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2014-12-22 03:46 AM

Document Chaining

Hi all,

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)?

Thanks,

273 Views
0 Likes
1 Reply
Not applicable
‎2014-12-22 03:58 AM
Author

Hi Paddy,

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.


hope that helps

Joe

161 Views