Documentation

SQL Operations Guide

Previous Topic

Next Topic

Template Database __Master.dbs Handling

FairCom DB SQL previously created new databases by copying a supplied template database, __Master.dbs. (This template was automatically created if it did not exist when needed.) FairCom DB SQL databases are now created directly without copying from a template database. This change typically results in faster database creation in the usual case of a single database.

It is possible to revert the behavior of the template database with the following configuration keyword:

SQL_OPTION FORCE_TEMPLATE_DB

This keyword forces template database creation upon server startup even if the template already exists (to ensure a consistent starting database). When this keyword is specified, FairCom DB SQL creates all new databases by copying the template database. Refer to the Appendix Server Configuration Keywords for a complete list of FairCom DB SQL-specific keywords.

TOCIndex