PC SOFT

WINDEV的在线文档

  • Overview
  • How to proceed?
  • Optimizzing the execution speed of the current query
  • Optimizing the execution speed of one or more queries
  • Optimization and composite keys
文档页面当前正在翻译。对于此延迟我们深表歉意。
您可以自愿地帮助我们翻译您想要的文档段落,然后只需通过以下地址与我们联系:info@cn.windev.com
产品
WinDevWebDev-服务器代码WebDev-浏览器代码WinDev Mobile报表和查询
平台
WindowsLinuxWindows MobileWindows PhoneWindows Store appsAndroidAndroid Widget iPhone/iPad
语言
JavaPHPAjax用户代码(MCU)外部语言
数据库
HFSQLHFSQL Client/Server存储过程HF 5.5OLE DBODBC本地访问

Overview
The query editor allows you to optimize the execution speed of one or more queries found in your project.

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.

ImportantReports & Queries cannot be used to optimize the execution speed of a query.

How to proceed?

Optimizzing the execution speed of the current query

To optimize the execution speed of the current query:
  1. Click(or select "Query .. Optimize the query").On the "查询" pane, in the "分析" group, click "查询优化".
  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 "查询" pane, in the "分析" group, click "查询优化".
  2. The window for query optimization is displayed and it proposes the different modifications that can be performed in the analysis.
Caution: Adding several composite keys to the analysis increases the size of the index files and may slow down the access to the 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 "项目" pane, in the "项目" group, click "描述". 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 the 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 the project: on the "项目" pane, in the "项目" group, click "描述". 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 the components in the composite key is not important.

There is no need to create a new key that just reverses the order of the components found in an existing key.