Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In Qlik NPRINTING I came to know that one NPRINTING app can have multiple connections. I have a query on this point.
Whether there would be any change in performance of the tasks if we have separate NPRINTING app for each connection rather than using same app for multiple connections.
Thank you
@vajid4525 let us know if those answers from Lucas & Ruggero helped!
Hello. Having multiple connections in one App shouldn't be a major factor in Task performance. Nprinting apps are more like 'Containers'. The task performance are based on other factors other than App connection. Please see the following link on what determines Nprinting Task performance.
https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DeployingQVNprinting/Performance.htm
Hi,
Currently there is no performance issue. My query is whether there would be any performance improvement in the task if we are avoiding multiple connections in one app.
Thank you
Hi,
Please:
- give a meaningful title to your community questions. The whole forum is about Qlik NPrinting
- attach the label with the correct version because the answer could depend on it. If you are using 17.3 it is not more supported and you have to upgrade your installation as soon as possible.
The answer to your question is: it depends.
When you create the cache of a connection the information like the list of fields, their distinct values, etc are stored in a table of the database (the Qlik NPrinting Repository). So more connections mean that the size of the table will increase. All connections in an app can be used to create reports on that app and this could help to minimize the number of connections and the size of the table. If you create one connection for each app it could be, it depends on your scenario, that you will be forced to create the same connection multiple times and the DB size will increase. When Qlik NPrinting runs it has to query the repository so a lighter DB means faster query responses.
In other words, to maximize the performances I suggest you avoid creating duplicates of the same connection.
Apps are useful if you need to segregate connection for security reasons because the minimum granularity of role privileges are by app. If in your scenario, you don't need to set different role privileges you can use a single app. Creating more apps, if you do not duplicate the same connections on many of them, will not impact performances.
Best Regards,
Ruggero
@vajid4525 let us know if those answers from Lucas & Ruggero helped!