This depends of:
The amount of data in the Qlik app.
The number of levels are used in a report.
The number of connections are used.
The amount of data you want to display in your report.
The number of reports you want to send via a task
The number of users connected to a task.
Unfortunately not a clear answer. For as far as I know is there not a limit of pages for a report.
I just would try it and test it.
My experience is I started with
Tried to run a basic report and it took 40mins if it ran at all.
Tried same report and it took 2mins to generate combined with release of 17.3
Having Levels really effects performance at the moment.
Currently upgrading box to
Will see how it goes. I need to get it under a couple of seconds per report published to a user to be production ready from a performance point of view.
A very important consideration when sizing an NPrinting system is the following:
Each available core will increase RAM requirements geometrically. 4 cores will consume twice the RAM as 2 cores.
Also, they type of connection you make will have a big impact on RAM consumption. "Local" connections to QWVs will open an instance of the QVW on the local machine for every core. Server connections and connections to Sense apps will consume much less RAM.
As an update the Ram update we went to 16 from 4 and this time it's 32.
We are using sense apps from a separate server and found the RAM consumption was fine it was the cores that were being used heavily.
I've been suggested this config as a good start point but obviously that's not what the minimum requirements say and bench marking data is just not available at the moment. hopefully this kind of work will help others.
We have cluster environment and currently run NPrint jobs from QDS machine with server connection.
- Are these virtual servers? do physical works better (as in case with QVS requirement)
- going above 16 cores, is there any big advantage?
- 16cores will require 32 gb? does CPU speed have big impact or memory speed?
- large number of users connecting to NewsStand, how much extra RAM does it consume.
- many ON-Demand report runs how much extra Ram does it consume.
- any other findings for optimization.