QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

Multi-engine deployment example - Large volume deployment of Excel reports from QlikView

In a multi-engine installation where a large report must be generated in MS Excel format for a high volume of users, the performance of the Qlik NPrinting Engines is important.

In this example, the reports are based on a single QlikView document of approximately 230 MB stored on disk, and 20 GB of RAM consumption. The QlikView document contains a single large table. Reports must be delivered to 700 Qlik NPrinting users, each with a single, dedicated filter. The MS Excel template contains a single table composed of a set of QlikView document columns filtered by user.

Deployed solution:

  • 2 QlikView Server 12.10 SR1 both installed on computers with 20 CPU cores and 256 GB of RAM
  • 1 Qlik NPrinting server installed on a computer with 8 CPU cores and 32 GB of RAM
  • 3 Qlik NPrinting Engines installed on computers with 12 CPU cores and 32 GB of RAM
  • To minimize generation time, the MS Excel template does not contain any other type of entity such as a level or chart.
  • Reports are delivered to folders so that email server delivery time is not a bottleneck.

Due to anti-spam settings, some SMTP servers may refuse to deliver a high number of emails a short time. If you want to use your SMTP server to deliver Qlik NPrinting reports, verify its configuration and test its performance.

In this example, the creation and delivery of 700 Excel reports takes approximately 15 minutes.

You can use the information in this page as a guideline to size your installation, but consider them only as guidelines. A different installation could perform differently.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?