Application Profiling is a set of tools that enable a developer to identify parts of an application that may be able to be improved when looking for performance issues.

• FSTAT – Counts file system operations (open, read, write, select, indexing, etc)
• HSM Hot Spot Monitor – Shows each program used during monitoring, counting number of time it was called, the processor time spent in that program and counts of file system activity (open, read, write, delete).
• Command Logging – Shows every command executed and where it came from.
• Lock Tracing – Gathers system wide data for every file lock or record lock action.
• Event Profiling – Gathers information for actions that may be critical to application performance (subroutine calls, file activity, command execution).

Multivalue database products do not normally impose validation rules when writing data to files. Instead, they largely rely on validation being performed when data is entered into the system. In some products, developers who wish to apply validation can do so via a pre-write trigger, rejecting the write request if the validation fails.

QM allows use of a pre-write trigger but also provides an alternative mechanism for hashed files where the validation rules for each field are defined in the dictionary and encoded into the data file in a manner that makes it impossible to skip the validation. This feature is known as Data Integrity Constraints. If both a pre-write trigger and data integrity constraints are present, the trigger is executed before the constraint validation.

MV Connect is a cross-platform Web/Rest API development package. The MV Connect API for QM is a set of QMBasic subroutines that can be used to build a web/rest application that works with QM’s internal WEBSVC webserver to expand its underlying functionality. These are equivalent functions to those in other languages such as working with headers, the body, form vars, return codes, etc. Additional information regarding these MV Connect APIs can be found here.

The MV Connect API library is provided as a separate package for download and installation as needed. It can be installed in the private catalogue of an individual account or in the global catalogue to make it available to all accounts.

• With a reputation as the most affordable and architecturally efficient PICK database, OpenQM fits in as little as 15MB, making it ideal to run on the tiny form factor devices like the Raspberry Pi.
• Starting at only $35, the Raspberry Pi allows you to deploy your PICK application in new places using OpenQM’s small, efficient footprint. With disk space around 5Mb for Linux and 10Mb for Windows and memory under 1Mb per user plus, the possibilities for deploying MultiValue apps are endless with OpenQM 4.0.