PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • How to proceed?
  • Optimizing the execution speed of current query
  • Optimizing the execution speed of one or more queries
  • Optimization and composite keys
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Warning
From version 23, this feature is no longer available.
Overview
The query editor allows you to optimize the execution speed of one or more queries.
The optimization of a query is based on the following principle: a wizard defines the composite keys to modify and/or to add into the analysis associated with the project.

Important

Reports & Queries cannot be used to optimize the execution speed of query.
How to proceed?

Optimizing the execution speed of current query

To optimize the execution speed of current query:
  1. Click (or select "Query .. Optimize the query").On the "Query" pane, in the "Analyze" group, click "Optimize the query".
  2. The window for query optimization is displayed and it proposes the different modifications that can be performed in the analysis.

Optimizing the execution speed of one or more queries

To optimize the execution speed of one or more queries:
  1. Click . On the "Query" pane, in the "Analyze" group, click "Optimize the query".
  2. The window for query optimization is displayed and it proposes the different modifications that can be performed in the analysis.
Caution: Adding a large number of composite keys to the analysis increases the index file size and may slow down the access to data files.
Note: This option is available only if the following conditions are fulfilled:
  • the Live Data is enabled ("Project .. Project description .. Live Data"). See Live Data for more details.the Live Data is enabled: on the "Project" pane, in the "Project" group, click "Description". Select the "Live Data" tab and check "Enable the Live Data". See Live Data for more details.
  • the data files are found in the test directory of project ("Project .. Project description .. Files"). See Running the test of a project for more details.the data files are found in the test directory of project: on the "Project" pane, in the "Project" group, click "Description". Select the "Files" tab. See Running the test of a project for more details.

Optimization and composite keys

To optimize your queries, the editor proposes the creation of composite keys. The order of components in the composite key is not important.
There is no need to create a new key that just reverses the order of components found in an existing key.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment