Performs various statistical calculations on the file keys.
This function is equivalent to HAccelerateSpeed.These statistics are used when implementing a filter, creating a query or creating a view on the data file. The HFSQL engine analyzes the selection condition, then uses these statistics to define the most discriminating items that will be used to optimize the browse operations on data files.
The statistics are used to get information about the content of the data file when they are calculated. Therefore, the more modifications are performed in the file after this calculation, the less these statistics represent the true content of the data file. The more records the data file contains, the less the modification of a single record impacts the overall statistics.
Caution:
<Source>.StatCalculate locks the data file in write mode while the statistics are calculated (a file browse is performed for each file key).
Remark: In order for the statistical calculation to be efficient, this calculation must be performed on all data files (for a multi-file query for example).
Versions 18 and later
New in version 18Versions 21 and later New in version 21 Versions 22 and later New in version 22
// Statistics on the CustName key of the Customer data file
Customer.StatCalculate(CustName)
Syntax
<Result> = <Source>.StatCalculate([<Key item> [, <Option>]])
<Result>: Boolean
- True if the calculation was performed,
- False if a problem occurred (data file locked by an application for example). HError is used to identify the error.
<Source>: Type corresponding to the specified source
Name of data file used.
Caution: This data file must not be locked by an application.
<Key item>: Optional character string (with or without quotes)
Name of key item used to perform the statistical calculation. If this name is not specified or if it is equal to "*", the statistics will be calculated for all key items found in the data file.
<Option>: Integer constant
Versions 15 and laterOption for calculating the statistics.
- If this parameter is not specified, the calculation of statistics locks the data file in write mode.
- If this parameter corresponds to the hBackgroundTask constant, the statistics are calculated in background task, without locking the data file.
Important: This parameter is taken into account for the HFSQL Client/Server files. In the other cases, the data file is automatically locked while the statistics are calculated.
New in version 15Option for calculating the statistics.
- If this parameter is not specified, the calculation of statistics locks the data file in write mode.
- If this parameter corresponds to the hBackgroundTask constant, the statistics are calculated in background task, without locking the data file.
Important: This parameter is taken into account for the HFSQL Client/Server files. In the other cases, the data file is automatically locked while the statistics are calculated.
Option for calculating the statistics. - If this parameter is not specified, the calculation of statistics locks the data file in write mode.
- If this parameter corresponds to the hBackgroundTask constant, the statistics are calculated in background task, without locking the data file.
Important: This parameter is taken into account for the HFSQL Client/Server files. In the other cases, the data file is automatically locked while the statistics are calculated.
Remarks
- <Source>.StatCalculate does not close the data file.
- The statistics can also be updated by <Source>.Index. <Source>.Index and <Source>.StatCalculate can both be used to update the file statistics.
- In the HFSQL Classic or Client/Server data files, the statistical calculation can only be performed on the key items.
- The syntax <Source>.StatCalculate(<Data file>) is equivalent to <Source>.StatCalculate(<Data file>, "*")
Versions 21 and laterTo use
<Source>.StatCalculate with the data files of an HFSQL cluster, the <Option> parameter must correspond to the
hBackgroundTask constant to avoid locking the cluster.
New in version 21To use
<Source>.StatCalculate with the data files of an HFSQL cluster, the <Option> parameter must correspond to the
hBackgroundTask constant to avoid locking the cluster.
To use <Source>.StatCalculate with the data files of an HFSQL cluster, the <Option> parameter must correspond to the hBackgroundTask constant to avoid locking the cluster.