I have a major problem in regard to load between filter in my QVW document. Each time I change the filter the load time of data between 20 -25 second which in my opinion is slow in loading the data.
QVW background:
- Data around 40 million row with 4 dimension table ( Store location, Merchandise, Calendar, Distribution channel)
- Around 20 straight table object with single column SUM function
The Spec of the server Dell Poweredge R720
- 2 pieces of Intel Xeon E5-2620 @ 2.00Ghz
- 512 GB of Memory
I have also attach my BIOS setting
If any Info is needed please let me know. Thank you.
