HOptimize (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Differences between HOptimize and HOptimizeQuery

Various

See also

ExecuteQueryAsynchronous

ExecuteSQLQueryAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

Differences between HOptimize and HOptimizeQuery
Various

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HOptimize (Function)

In french: HOptimize

Available only with this kind of connection

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.

Example

HOptimize(Customer, Name)

Syntax

<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 (with or without quotes)

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 (with or without quotes)

Name of the key item to optimize. If this parameter is not specified, HOptimize optimizes all the keys found in the data file.

Remarks

Differences between HOptimize and HOptimizeQuery

HOptimize loads the system caches with the entire index of the data file. 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, HOptimize should not be called on an important number of data files or key items.
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.

Various

HOptimize immediately gives control back to the program and it is run in background task.
HOptimize has no effect on the non-key items or on the data files that are not in HFSQL Classic format.

Component: wd260hf.dll