Database Connection Counts (Advanced Topic)

KB Home   |   Database Connection Counts (Advanced Topic)

PaperCut technical support are sometimes asked “How many database connections will PaperCut need?”

It’s a fairly innocuous question, but giving an exact answer is not easy as there are many variables that contribute to how many database connections PaperCut will use.

For example, the following events can cause one or more database connections to happen:

As you can see PaperCut has many areas where it will momentarily use a database to either read, update or store new information.

Obviously we have gone to lengths to make sure we’re as efficient as caffinely possible. We make use of Connection Pooling and Connection Reuse algorithms. For example, one connection might be used to update a users balance because they’ve just printed a document, then a few milliseconds later we need to check the email address of another user, we’ll re-use that connection rather than close and reopen one. Once a connection has become idle for a while (configurable) we’ll close the connection.

This means that the total number of database connections can not be directly correlated to the number of print jobs, user sessions or copiers, etc as not all of these processes happen at the same time.

Under normal operating conditions the number of database connections will remain consistently low. The number will increase to meet demand and reduce down afterwards. This can lead to spikes in the number of connections during busy moments, for example a remote office’s internet connection has started working again or a large batch of print jobs is released.

Please note: Unexpected behaviour can occur if a database has been configured to restrict the number of connections that PaperCut can make to an external DBMS. For sites dealing with high print volumes and many users, this number may need to be as high as 400 simultaneous connections.


Categories: Databases, Architecture, Troubleshooting


Keywords: database connection limits, too many connections, how many connections

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.

Article last modified on July 16, 2012, at 12:39 AM
Printable View   |   Article History   |   Edit Article