PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE


  • Dynamic load balancing
  • Managing logs
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
HSetServer (Function)
In French: HGèreServeur
HFSQL Client/ServerAvailable only with this kind of connection
Allows you to find out and modify some settings of HFSQL Client/Server server.
Note: The rights to manage the server are required to use this function. These rights correspond to the hRightsManageServer constant used in HInfoServerRights and HModifyServerRights.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
Java This function is now available for the Java applications.
New in version 22
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
Java This function is now available for the Java applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
Java This function is now available for the Java applications.
Example
// Disable the management of audit logs for the server
HSetServer("MyConnection", hLogLevel, "")
Syntax

Finding out the value of a parameter Hide the details

<Result> = HSetServer(<Connection Name> , <Option>)
<Result>: Character string
  • Value of specified option.
  • Empty string ("") if the option is not defined.
<Connection Name>: Character string (with or without quotes)
Name of connection to the server for which the value of <Option> is requested.
<Option>: Integer constant
Specifies the option to know. These options are stored in the HFConf.ini file, found at the server root.
List of available options:
Versions 23 and later
hActiveDirectory
New in version 23
hActiveDirectory
hActiveDirectory
<Enable> parameter of ACTIVEDIRECTORY section of HFConf.Ini file.
Enable the authentication via Active Directory.
Value:
  • 0, the authentication via Active Directory is not enabled,
  • 1, the authentication via Active Directory is enabled.
Versions 21 and later
hCacheNbUnusedFiles
New in version 21
hCacheNbUnusedFiles
hCacheNbUnusedFiles
<CacheMaxUnusedFiles> parameter of HFConf.Ini file.
Maximum number of unused HFSQL tables that are stored in cache (which means opened) on the server. When this number is reached, the less recent unused table is automatically deleted from the cache.
Versions 18 and later
hAutoStatisticalCalc
New in version 18
hAutoStatisticalCalc
hAutoStatisticalCalc
<Enable> parameter of AUTOANALYSIS section of HFConf.Ini file.
Enable the automatic calculation of statistics for the data files (optimization of indexes).
Value:
  • 0, the automatic statistical calculation is not enabled,
  • 1, the automatic statistical calculation is enabled.
hDatabasePath<DBRootPath> parameter of HFConf.Ini file.
Path of directory containing all databases (which means the data files of different HFSQL Client/Server applications).
hJNLPath<JNLRootPath> parameter of HFConf.Ini file.
Path of directory containing all the logs of different HFSQL Client/Server applications (history of write operations performed in the HFSQL data files).
hJNLBackupPath<JNLBackupRootPath> parameter of HFConf.Ini file.
Path of directory containing the backup of logs.
hLogPath<ServerLogPath> parameter of HFConf.Ini file.
Path of directory containing all the audit log files of server (all the operations requested by the client computers from the server).
hActivityStatisticsPath<StatisticPath> parameter of HFConf.Ini file.
Path of directory containing the files of activity statistics.
hDaemonUser<DaemonUser> parameter of HFConf.Ini file.
User name under which the server will operate.
hlbDiskAccess<LoadCoeffDiskAccess> parameter of HFConf.Ini file.
Global coefficient for the number of accesses to the disk.
hlbActive<LoadEnable> parameter of HFConf.Ini file.
Indicates whether load balancing is enabled or not.
hlbClientCalls<LoadCoeffCall> parameter of HFConf.Ini file.
Global coefficient for the number of client calls.
hlbMaxTimeout<LoadMaxWait> parameter of HFConf.Ini file.
Maximum time (in ms) during which a request to the server can be temporarily stopped by the system for load balancing before it is processed.
hlbDisk<LoadCoeffDisk> parameter of HFConf.Ini file.
Global coefficient for the number of bytes read or written on disk.
hlbSent<LoadCoeffSend> parameter of HFConf.Ini file.
Global coefficient for the number of bytes sent over the network.
hlbReceived<LoadCoeffRecv> parameter of HFConf.Ini file.
Global coefficient for the number of bytes received on the network.
Versions 23 and later
hkaInterval
New in version 23
hkaInterval
hkaInterval
<KeepAliveInterval> parameter of HFConf.Ini file.
Maximum time (in seconds) after which, if no communication is established between the server and the client, the server will check the presence of client.
This parameter is set to 30 minutes by default.
Versions 23 and later
hkaTimeout
New in version 23
hkaTimeout
hkaTimeout
<KeepAliveTimeout> parameter of HFConf.Ini file.
Maximum time-out (in seconds) for the server when checking the presence of client. If the client is not found at the end of this time-out, the client is automatically disconnected.
This parameter is set to 2 minutes by default.
hMode2GB<MoreThan2GB> parameter of HFConf.Ini file.
Specifies whether the size of system tables can exceed 2 GB.
Note: the operating system must support the files exceeding 2 GB.
hLogLevel<ServerLogLevels> parameter of HFConf.Ini file.
Defines the elements that must be found in the log file.
hActivityStatisticsPeriod<StatisticPeriod> parameter of HFConf.Ini file.
Indicates the period (in second) between each backup of values for the different activity counters. You have the ability to specify 0 to stop collecting statistics.
hDebuggingPort<WLDebugPort> parameter of HFConf.Ini file.
Port used to debug the stored procedures and the Client/Server triggers.
hServerPort<AccessPort> parameter of HFConf.Ini file.
Network port used.
Versions 22 and later
hFindKey
New in version 22
hFindKey
hFindKey
<KeySearch> parameter of HFConf.Ini file.
Enable the search for keys.
Value:
  • 0, the automatic search for keys is not enabled,
  • 1, the automatic search for keys is enabled.
Versions 17 and later
hTempDirectory
New in version 17
hTempDirectory
hTempDirectory
<TmpPath> parameter of HFConf.Ini file.
Path of temporary directory. This directory is used to create the temporary files if necessary (temporary files created when reindexing large data files for example).
Versions 19 and later
hWindowsDiskCacheSize
New in version 19
hWindowsDiskCacheSize
hWindowsDiskCacheSize
<WindowsFileCacheSize> parameter of HFConf.ini file
Configure the management of the size for the disk cache of Windows.
Value:
  • -1, for a size that is automatically calculated,
  • 0, for an unlimited cache size,
  • a positive value corresponds to a custom cache size.
Note: The standard management of Windows disk caches in 64-bit mode (independently from HFSQL) can create memory saturation. This constant is used to customize the management of memory caches.
hNdxCacheSize<NdxCacheSize> parameter of HFConf.Ini file.
Size of the index cache (in MB). The default value is 10 MB.
hMaxLogSize<ServerLogMaxSize> parameter of HFConf.Ini file.
Maximum size of a log file (in MB).
hMaxActivityStatisticsSize<ActivityStatisticMaxFileSize> parameter of HFConf.Ini file.
Maximum size of a file for activity statistics (in MB).
Versions 22 and later
hTelemetryEnable
New in version 22
hTelemetryEnable
hTelemetryEnable
<Active> parameter of TELEMETRY section of HFConf.ini file
Configure the transmission of data in order to improve the HFSQL server.
Value:
  • 1 if the transmission of data (telemetry) was enabled when installing the HFSQL server,
  • 0 if the transmission of data (telemetry) was refused when installing the HFSQL server,
  • another value if no choice was made during the setup regarding the use of telemetry. The question will be asked again during the next setup of HFSQL server.
Note: If the "TELEMETRY" section does not exist in the HFConf.ini file, the transmission of data regarding the use of product is not enabled for the HFSQL server.

Modifying the value of a parameter Hide the details

<Result> = HSetServer(<Connection Name> , <Option> , <Value>)
<Result>: Character string
  • Former value of option,
  • Empty string ("") if an error occurred.
<Connection Name>: Character string (with or without quotes)
Name of connection to the server for which the value of <Option> will be modified.
<Option>: Integer constant
Specifies the option to know. These options are stored in the HFConf.ini file, found at the server root.
Note: A detailed description of each parameter is available on the HFConf.ini page
  • List of options for a standard use:
    Note: These modifications are taken into account without having to restart the server.
    Versions 23 and later
    hActiveDirectory
    New in version 23
    hActiveDirectory
    hActiveDirectory
    <Enable> parameter of ACTIVEDIRECTORY section of HFConf.Ini file.
    Enable the authentication via Active Directory.
    Value:
    • 0, the authentication via Active Directory is not enabled,
    • 1, the authentication via Active Directory is enabled.
    Versions 18 and later
    hAutoStatisticalCalc
    New in version 18
    hAutoStatisticalCalc
    hAutoStatisticalCalc
    <Enable> parameter of AUTOANALYSIS section of HFConf.Ini file.
    Enable the automatic calculation of statistics for the data files (optimization of indexes).
    Value:
    • 0, the automatic statistical calculation is not enabled,
    • 1, the automatic statistical calculation is enabled.
    hLogPath<ServerLogPath> parameter of HFConf.Ini file.
    Path of log files. The path is created on the server if it does not exist.
    hActivityStatisticsPath<StatisticPath> parameter of HFConf.Ini file.
    Path of files for activity statistics. The path is created on the server if it does not exist.
    The statistics are saved and reinitialized.
    hLogLevel<ServerLogLevels> parameter of HFConf.Ini file.
    Defines the elements that must be found in the log file.
    Versions 23 and later
    hkaInterval
    New in version 23
    hkaInterval
    hkaInterval
    <KeepAliveInterval> parameter of HFConf.Ini file.
    Maximum time (in seconds) after which, if no communication is established between the server and the client, the server will check the presence of client.
    This parameter is set to 30 minutes by default.
    Versions 23 and later
    hkaTimeout
    New in version 23
    hkaTimeout
    hkaTimeout
    <KeepAliveTimeout> parameter of HFConf.Ini file.
    Maximum time-out (in seconds) for the server when checking the presence of client. If the client is not found at the end of this time-out, the client is automatically disconnected.
    This parameter is set to 2 minutes by default.
    hActivityStatisticsPeriod<StatisticPeriod> parameter of HFConf.Ini file.
    Indicates the period (in seconds) between each backup of values for the different activity counters.
    This value must be greater than or equal to 1 otherwise no modification is performed.
    The statistics are saved and reinitialized.
    You have the ability to specify 0 to stop collecting statistics.
    Versions 22 and later
    hFindKey
    New in version 22
    hFindKey
    hFindKey
    <KeySearch> parameter of HFConf.Ini file.
    Enable the search for keys.
    Value:
    • 0, the automatic search for keys is not enabled,
    • 1, the automatic search for keys is enabled.
    Versions 17 and later
    hTempDirectory
    New in version 17
    hTempDirectory
    hTempDirectory
    <TmpPath> parameter of HFConf.Ini file.
    Path of temporary directory. This directory is used to create the temporary files if necessary (temporary files created when reindexing large data files for example).
    The path is created on the server if it does not exist.
    hNdxCacheSize<NdxCacheSize> parameter of HFConf.Ini file.
    Size of the index cache (in MB).
    This value must be greater than or equal to 1 otherwise no modification is performed.
    hMaxLogSize<ServerLogMaxSize> parameter of HFConf.Ini file.
    Maximum size of a log file (in MB).
    This value must be greater than or equal to 1 otherwise no modification is performed.
    hMaxActivityStatisticsSize<StatisticMaxFileSize> parameter of HFConf.Ini file
    Maximum size of a file for activity statistics (in MB).
    This value must be greater than or equal to 1 otherwise no modification is performed.
    The statistics are saved and reinitialized.
    Versions 22 and later
    hTelemetryEnable
    New in version 22
    hTelemetryEnable
    hTelemetryEnable
    <Active> parameter of TELEMETRY section of HFConf.ini file
    Configure the transmission of data regarding the use of HFSQL server in order to improve the product.
    Value:
    • 1 if the transmission of data (telemetry) was enabled when installing the HFSQL server,
    • 0 if the transmission of data (telemetry) was refused when installing the HFSQL server,
    • another value if no choice was made during the setup regarding the use of telemetry. The question will be asked again during the next setup of HFSQL server.
    Note: If the "TELEMETRY" section does not exist in the HFConf.ini file, the transmission of data regarding the use of product is not enabled for the HFSQL server.
  • List of options for an advanced use:
    Note: These modifications will be taken into account when restarting the server.
    hDatabasePath<DBRootPath> parameter of HFConf.Ini file.
    Path of the directory containing all the databases (which means the data files of different HFSQL Client/Server applications).
    The path is created on the server if it does not exist when restarting the server.
    hJNLPath<JNLRootPath> parameter of HFConf.Ini file
    Path of the directory containing all the logs of the different HFSQL Client/Server applications.
    The path is created on the server if it does not exist when restarting the server.
    hJNLBackupPath<JNLBackupRootPath> parameter of HFConf.Ini file.
    Path of the directory containing the backup of logs.
    The path is created on the server if it does not exist when restarting the server.
    hDaemonUser<DaemonUser> parameter of HFConf.Ini file.
    User name that will be used by the server.
    hMode2GB<MoreThan2GB> parameter of HFConf.Ini file.
    Specifies whether the size of system tables can exceed 2 GB.
    Note: the operating system must support the files exceeding 2 GB.
    hServerPort<AccessPort> parameter of HFConf.Ini file.
    Network port used.
    Versions 19 and later
    hWindowsDiskCacheSize
    New in version 19
    hWindowsDiskCacheSize
    hWindowsDiskCacheSize
    <WindowsFileCacheSize> parameter of HFConf.ini file
    Mode for managing the size of Windows disk cache.
    Value:
    • -1, for a size that is automatically calculated,
    • 0, for an unlimited cache size,
    • a positive value indicates a custom cache size.
    Note: The standard management of Windows disk caches in 64-bit mode (independently from HFSQL) can create memory saturation. This constant is used to customize the management of memory caches.
  • List of options for load balancing:
    Note: These modifications are taken into account without having to restart the server.
    hlbDiskAccess<LoadCoeffDiskAccess> parameter of HFConf.Ini file.
    Global coefficient for the number of accesses to the disk.
    This value (included between -100 and 100) increases or reduces the coefficient applied to the counter for the number of disk accesses.
    hlbActive<LoadEnable> parameter of HFConf.Ini file.
    Indicates whether load balancing is enabled or not.
    • True if the load balancing must be enabled ,
    • False otherwise.
    hlbClientCalls<LoadCoeffCall> parameter of HFConf.Ini file.
    Global coefficient for the number of client calls.
    This value (included between -100 and 100) increases or reduces the coefficient applied to the counter for the client calls to the server.
    hlbMaxTimeout<LoadMaxWait> parameter of HFConf.Ini file.
    Maximum time (in ms) during which a request to the server can be temporarily stopped by the system for load balancing before it is processed.
    hlbDisk<LoadCoeffDisk> parameter of HFConf.Ini file.
    Global coefficient for the number of bytes read or written on disk.
    This value (included between -100 and 100) increases or reduces the coefficient applied to the counter for the bytes read or written on disk by the server.
    hlbSent<LoadCoeffSend> parameter of HFConf.Ini file.
    Global coefficient for the number of bytes sent over the network.
    This value (included between -100 and 100) increases or reduces the coefficient applied to the counter for the bytes sent by the server.
    hlbReceived<LoadCoeffRecv> parameter of HFConf.Ini file.
    Global coefficient for the number of bytes received on the network.
    This value (included between -100 and 100) increases or reduces the coefficient applied to the counter for the bytes received by the server.
<Value>: Variant
New value for the specified option.
Remarks

Dynamic load balancing

The coefficients are used to modify the importance of each counter in the formula for calculating the load generated by a user on the server.
  • A value equal to 1, 0 or -1 does not modify the coefficient.
  • A value greater than 100 is equivalent to 100.
  • A value less than -100 is equivalent to -100.

Managing logs

The information about the logs can be modified without restarting the server. We advise you to modify the path of logs before they are enabled. Otherwise, the logs will be written in the default directory between the activation and the change of path.
Related Examples:
The HSetServer function Unit examples (WINDEV): The HSetServer function
[ + ] Using the HSetServer of WINDEV.
This function is used to modify some parameters on the HFSQL server.
It allows you to configure your server more efficiently.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment