PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Principle
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
Managing the load balancing (dynamic load balancing on server)
HFSQL Client/ServerAvailable only with this kind of connection
Overview
The server that is hosting a HFSQL database engine can be very busy.
HFSQL proposes to share the server resources according to 2 modes:
  • The automatic mode, that shares the resources according to the number of accesses to the server. A process that requires a lot of resources will share its execution time with smaller processes. Therefore, a large process will have no effect on the other accesses.
  • The priority mode, that shares the resources according to their priority. A process with a high priority will use most of the server resources. This enables you to limit the resources of a client computer that runs a lot of simultaneous accesses: the other users will not be affected.
The priority mode can be managed "dynamically", without having to restart the server by programming (HPriority et HPriorityClient).
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Principle
For each user, a load factor is calculated for his operations performed on the server. This load factor is calculated in real time. The resources are allocated to the user according to this load factor.
In automatic mode, only this load is taken into account.
In priority mode, HPriority and HPriorityClient are used to change the load of the user.
The load of each user is calculated from several coefficients. The importance of each counter can be modified in the formula for calculating the load of each user on the server. This setting (advanced feature) can be performed by the constants of HSetServer.
Minimum required version
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment