How does look like you data model?
How is you server ? RAM/CPU/ Nbr of concurrents User? Size of Document?
How is the content of the complexity of the document? (ex displaying straight table with complex set analysis on 5 milions rows is CPU consumming, add some aggr function within and you'll need also some more RAM...
Is the QVS running on a virtual machine, if yes does the VM is dedicated to QV?
You could run some load testing with JMeter
5 million rows should not be any problem for QlikView. Probably more of a problem because of one or more of the following:
- Not enough memory. Monitor your server memory usage. QVS becomes awfully slow when running short on memory.
- Not enough CPUs for parallel resolving of selections and associations. Monitor your server CPU usage.
- Your datamodel may be sub-optimal. Try not to use any excessive table chains. Throwing it all in one big table makes for a incredibly responsive application, on condition that the previous items are all ok.