Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
  • Differences between HOptimize and HOptimizeQuery
  • Miscellaneous
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
Allows you to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter. Optimizes the access to the indexes of HFSQL Classic data files (the indexes of HFSQL Client/Server data files cannot be optimized). Remark: From version 19, HFSQL is the new name of HyperFileSQL.
HOptimize(Client, Nom)
<Result> = HOptimize([<Data file> [, <Key item>]])
<Result>: Boolean
  • True if the file was optimized,
  • False if a problem occurred. HErrorInfo returns more details.
<Data file>: Optional character string
Name of the HFSQL Classic data file used. If this parameter is not specified, HOptimize will use the last data file used by the last HFSQL management function (function starting with "H").
<Key item>: Optional character string
Name of the key item to optimize. If this parameter is not specified, function HOptimize optimizes all of the data file.

Differences between HOptimize and HOptimizeQuery

  • The HOptimize function loads the system caches with the entire of the data file index. There is a risk of overloading the system caches if the data file is very large or if the application uses several large data files.
    To avoid the risk of saturation, avoid calling function HOptimize on too many data files or key wage types.
  • HOptimizeQuery loads the system caches with the index sections required by the specified query, for all the data files used by the query. This function is used to optimize the queries.


  • The function HOptimize returns the hand immediately to the program and is executed as a task of Background.
  • The HOptimize function has no effect on non-key fields or on data files that are not in HFSQL Classic format.
Component: wd270hf.dll
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment