Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
vajid4525
Contributor II
Contributor II

QLIK NPRINTING

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

Labels (2)
1 Solution

Accepted Solutions
David_Friend
Support
Support

@vajid4525 let us know if those answers from Lucas & Ruggero helped!

View solution in original post

4 Replies
Lucas_Gatling
Support
Support

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

 

If the issue is solved please mark the answer with Accept as Solution.
vajid4525
Contributor II
Contributor II
Author

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 

Ruggero_Piccoli
Support
Support

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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
David_Friend
Support
Support

@vajid4525 let us know if those answers from Lucas & Ruggero helped!