What is the maximum number of users who can access a PaperOffice database at the same time?

Please note that PaperOffice assumes no responsibility for the accuracy and completeness of your setup or data backup and recovery on third-party software and hardware. Contact your hardware service provider or use our paid support if you need help.

PaperOffice always builds in SQL mode technically on a MySQL or MariaDB database server, which by default supports 250 concurrent connections.

MySQL and MariaDB support up to 100,000 concurrent connections, depending on the version, hardware and platform, for a maximum PaperOffice user count of over 6,000.

Each database connection requires resources and memory on the database server, which may be e.g. can be calculated here> https://www.mysqlcalculator.com

Each user logged into PaperOffice dynamically uses up to a maximum of 180 simultaneous connections to this database server, which means that by default, at least 10 users can be logged in simultaneously. For example, each logged-in user needs about 60MB of memory, but this can vary as long as you change the default settings.

As a rule of thumb, the more RAM, the better and faster. The following list can serve as a guideline for the least amount of storage:

  • 1 user = ca.60MB RAM needed
  • 10 users = ca.600MB RAM needed
  • 25 users = ca.1.5GB RAM needed
  • 50 users = approx. 3GB of RAM needed
  • 100 users = approx. 6GB of RAM needed