PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
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
Starts collecting information on executed queries to propose optimization keys.
From this function, the queries executed on the connection passed as a parameter are analyzed to propose a set of keys to be added to your data files and improve the performance of your queries.
To obtain the result of the analysis, HSuggereKeyEnd must be executed.
Example
HSuggestKeyStart(MaConnexion)
// Exécuter des requêtes sur la connexion MaConnexion
// avec les fonctions HExécuteRequêteSQL et HExécuteRequête
...
// Obtenir les suggestions
sLesClésSuggérées is string = RTFToText(HSuggestKeyEnd(MaConnexion))
Syntax
HSuggereKeyBegin(<Connection>)
<Connection>: Character string or Connection variable
Connection to the HFSQL server containing the queries to be analyzed. This connection corresponds to:
Remarks
  • The result obtained with HSuggereKeyEnd 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
Minimum version required
  • Version 26
This page is also available for…
Comments
Click [Add] to post a comment