HSuggestKeyEnd (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

HFSQL Client/Server functions

HAddScheduledOptimization

HCS.FrameSize (Variable)

HCS.Timeout (Variable)

HDeleteScheduledBackup

HDeleteScheduledOptimization

HExecuteScheduledBackup

HExecuteScheduling

HInfoBackup

HInfoDatabaseProperty

HInfoDatabaseRights (Example)

HInfoDatabaseRights

HInfoFileProperty

HInfoFileRights (Example)

HInfoServerRights (Example)

HListScheduledOptimization

HModifyDatabaseProperty

HModifyDatabaseRights

HModifyFileProperty

HModifyFileRights

HModifyGroup

HModifyScheduledBackup

HModifyScheduledOptimization

HModifyScheduling

HModifyServerProperty

HNotifAddEmailRecipient

HNotifConfigure

HNotifDeleteCCRecipient

HNotifDeleteEmailRecipient

HNotifListCCRecipient

HNotifListEmailRecipient

HRestoreBackup (Example)

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HSuggestKeyEnd (Function)

In french: HSuggèreCléFin

Not available

Finishes collecting information on executed queries to propose optimization keys.

Queries executed from the call to HSuggestKeyStart are analyzed to propose a set of keys to be added to your data files and improve the performance of queries.

Example

HSuggestKeyStart(MyConnection)
// Execute queries on MyConnection
// with HExecuteSQLQuery and HExecuteQuery
...
// Get suggestions
sSuggestedKeys is string = RTFToText(HSuggestKeyEnd(MyConnection))

Syntax

<Result> = HSuggestKeyEnd(<Connection>)

<Result>: Character string

Readable message for the developer, containing the list of keys to be added to the data files in order to optimize the queries.

<Connection>: Character string or Connection variable

Connection to the HFSQL server containing the queries to be analyzed. This connection corresponds to:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a variable of type Connection.

Remarks

The result obtained with HSuggestKeyEnd will take into account the 10 slowest queries. It is recommended to execute the same query multiple times with different parameters to obtain more useful results.
To analyze a query with a parameter, you must provide the value of the parameter when the query is executed.
If no value is given for the query parameter(s), the query condition will not be taken into account. In that case, no keys will be suggested.
Keys are suggested according to the data contained in the data file. If a data file contains no data, no key will be suggested.

Business / UI classification: Business Logic

Component: wd270hf.dll