ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / Types of HFSQL variables
  • Properties specific to hScheduledOptimization variables
  • Functions that handle the hScheduledOptimization type
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
hScheduledOptimization (Type of variable)
In french: hOptimisationPlanifiée
HFSQL Client/ServerAvailable only with this kind of connection
The hScheduledOptimization type is used to programmatically manage a scheduled optimization task on an HFSQL server. A scheduled optimization task periodically performs statistical calculations or reindexes the data files on the HFSQL server.
The characteristics of this scheduled optimization task can be defined and modified by several WLanguage properties.
Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see "Declaring a variable".
Example
// Recalculate the statistics for the files found in "MyDatabase" every Saturday at 23:00
Optim is hScheduledOptimization
Optim.Description = "Recalculating the statistics for the files found in the MyDatabase database"
 
Optim.Scheduling.Month = "*"
Optim.Scheduling.DayOfWeek = "Saturday"
Optim.Scheduling.Hour = "23"
Optim.Scheduling.Minute = "0"
 
Optim.File[1].Name = "MyDatabase"
Optim.File[1].Option = hOptStat
 
HAddScheduledOptimization(MyConnection, Optim)
Remarks

Properties specific to hScheduledOptimization variables

The following properties can be used to handle hScheduledOptimization variables:
Property nameType usedEffect
DescriptionCharacter stringText describing the scheduling of the optimization.
The description of the optimization scheduling corresponds to an empty string ("") by default.
EnabledBoolean
  • True if the scheduling of the optimization is enabled,
  • False otherwise.
FileArray of hFileParameter variablesDescription of the files that must be taken into account during the optimization.
IdentifierIntegerIdentifier of the optimization task.
This property is read-only.
NumberExecutionIntegerNumber of times the task for optimization scheduling must be run. This property can also correspond to the Infinite constant.
SchedulinghScheduling variableCharacteristics of the scheduling.
UserCharacter stringUser who created the task for optimization scheduling.
This property is read-only.

Functions that handle the hScheduledOptimization type

The following functions can be used to handle hScheduledOptimization variables:
HAddScheduledOptimizationAdds an optimization task of HFSQL Client/Server data files.
HListScheduledOptimizationLists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
HModifyScheduledOptimizationModifies a scheduled optimization task on the HFSQL server defined by the connection.
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help