What is "QuickLoadDocID" and How to Use It with SQLite?

Modern PrintBOS environments require efficient handling of templates and job requests. QuickLoadDocID significantly enhances system performance by reducing template load times and improving overall system efficiency.

What is "QuickLoadDocID" and How to Use It?

QuickLoadDocID is designed to accelerate the full loading and readiness of "PrintPRS" by preloading 53 mandatory parameters required for precise identification and retrieval of templates for a specific Job request.

These 53 mandatory parameters can be stored locally in an SQLite file (PBAPPPARAMS) or managed through an SQL server.

PrintBOS Template

A collection of components, including FMT, SMT, scripts, images, and other elements.

Example of Usage in an Environment

A given environment has two PrintBOS servers with different tasks:

• PrintBOS_Server_1 – has its own individual set of templates and components.
• PrintBOS_Server_2 – has its own individual set of templates and components.

Given these different environments, optimizing template loading becomes crucial to ensuring smooth PrintBOS operations. The following section explains how to configure QuickLoadDocID to maximize performance.

How to Use QuickLoadDocID to Improve Performance?

Using a local SQLite file (PBAPPPARAMS) is recommended separately for each PrintBOS server.

Implementation Steps:

1. Open PrintBOS UI and navigate to Server Administrator Settings.

2. In the CFG section, set the QUICKLOADDOCID parameter to 1.
3. In the SET 1 section, add the following value for the DB Connection String:

PB_USE_REPORT_DB=SQLITE;


4. Save changes by clicking Apply.
5. Fully restart PrintBOS (no need for a full VM reboot).
6. Once the PrintBOS server is operational again, execute Reload Templates.

Important!

These steps must be performed on all operational PrintBOS servers. After completing these steps, a file named PBREPORTPARAMS.IDB will be created (separately for each server) in the directory C:\BSPRBOSS\Reports, or in the registered paths from Registry. This file contains 53 mandatory parameters for each FMT template.

What Are the Benefits?

Each PrintPRS on every PrintBOS server loads its required set of templates at startup. However, all PrintBOS servers share a single SQL database for request tracking and statistics.

Critical Note!

Any modifications to any PrintBOS project require executing Reload Templates on the machine where the changes were made.