PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • General
  • Logs
  • Logs
  • Activity statistics
  • System
  • Caches
  • Notifications
  • Replication
  • Version
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Configuration of HFSQL server
HFSQL Client/ServerAvailable only with this kind of connection
Overview
The HFSQL Control Center proposes a full management of HFSQL servers.

To display the characteristics of a HFSQL server:
  1. Connect (if necessary) to a HFSQL server. See Managing HFSQL Client/Server databases for more details.
  2. Double-click the name of HFSQL server in the tree structure.
  3. The right section of Control Center displays a tab with the server name. This tab includes:
    • several tabs used to manage the characteristics of HFSQL server.
    • a ribbon used to configure the HFSQL server.
In the ribbon, in the "Parameters" group, the option "Configuring the server" is used to manage all the options for configuring the HFSQL server.
Ribbon for a
Note: From version 19, HFSQL is the new name of HyperFileSQL.
General
In the window for server configuration, click "General". The following options are displayed:
Server configuration,
You can configure:
  • The location of databases on the server, which means the data files of the different HFSQL Client/Server applications. Shortcuts can be used to indicate the specific directories:
    • "%%EXE%%": Directory of Manta service.
    • "%%COMMONAPPDATA%%": Directory of data common to all applications.
  • The statistical calculations on the keys: Enabling this option allows you to automatically optimize the execution of queries and filters.
  • Local storage directory: This directory contains all the retrieved data (logs and statistics) in order to perform consolidations over long periods.
Logs
In the window for server configuration, click "Log files". The following options are displayed:
Server configuration,
You have the ability to define the directory for the logs and their backup.
Logs
In the window for server configuration, click "Log files". The following options are displayed:
Server configuration,
You can:
  • specify the directory of log files.
  • enable the backup of calls to the server in the log file.
  • enable the backup of call parameters in the log file.
You also have the ability to specify the maximum size for log file.
Activity statistics
In the window for server configuration, click "Activity statistics". The following options are displayed:
Server configuration,
The activity statistics are used to measure the server workload. You can:
  • enable the activity statistics,
  • specify the backup directory,
  • specify the maximum file size,
  • specify the period for calculating performances (in seconds).
System
In the window for server configuration, click "System". The following options are displayed:
Server configuration,
  • Listening port,
  • User account of server (Linux only)
  • Allow the sizes exceeding 2 GB for the system files
  • Port for remote debugging, ...
Caches
In the window for server configuration, click "Caches". The following options are displayed:
Server configuration,
  • Size of index cache.
    Note: in 32 bits, the size of index cache is limited to 1GB.
  • Disk cache (Windows server only): The standard management of Windows disk caches in 64-bit mode (independently from HFSQL) can create memory saturation. This option is used to customize the management of memory caches.
Notifications
In the window for server configuration, click "Notifications"
This option is used to manage the recipients of notifications.
Caution: the configuration for sending notifications is required before adding recipients.
See Notifications of a HFSQL server for more details.
Replication
In the window for server configuration, click "Replication"
This option is used to configure the server replication. See Replication of HFSQL servers for more details.
Versions 22 and later
Version
In the window for server configuration, click "Version"
This option is used to:
  • Find out the current version of the server:
    • Major version: Version corresponding to the version of the HFSQL engine used by the server.
    • Minor version: Number of the update used.
    • Language: Language used for the server.
    The link "More details" is used to get the details of the modules used.
  • Implement the automatic server update. If this option is enabled, the HFSQL server can be automatically updated as soon as a new version is available:
    • on the PC SOFT server.
    • on a custom server.
    See Updating the server for more details.
New in version 22
Version
In the window for server configuration, click "Version"
This option is used to:
  • Find out the current version of the server:
    • Major version: Version corresponding to the version of the HFSQL engine used by the server.
    • Minor version: Number of the update used.
    • Language: Language used for the server.
    The link "More details" is used to get the details of the modules used.
  • Implement the automatic server update. If this option is enabled, the HFSQL server can be automatically updated as soon as a new version is available:
    • on the PC SOFT server.
    • on a custom server.
    See Updating the server for more details.
Version
In the window for server configuration, click "Version"
This option is used to:
  • Find out the current version of the server:
    • Major version: Version corresponding to the version of the HFSQL engine used by the server.
    • Minor version: Number of the update used.
    • Language: Language used for the server.
    The link "More details" is used to get the details of the modules used.
  • Implement the automatic server update. If this option is enabled, the HFSQL server can be automatically updated as soon as a new version is available:
    • on the PC SOFT server.
    • on a custom server.
    See Updating the server for more details.
Minimum required version
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment