ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Tools / WDOptimizer
  • Overview
  • WDOptimizer
  • Use
  • Starting WDOptimizer
  • Use conditions
  • Required files
  • Reminder: Indexing a data file
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview

WDOptimizer

The different operations that can be performed with WDOptimizer are as follows:
  • Index optimization
    This option allows you to perform several types of operation:
    1. Check indexes Checks consistency between index and data files.
    2. Optimize index speed (Re-calculate statistics) Optimize indexes by calculating index statistics. These statistics are used to optimize the filters, the queries and the HFSQL views.
      Note: The more the data file is modified, the less the statistics reflect the content of the HFSQL data file.. The more records the data file contains, the less the modification of a single record impacts the overall statistics.
    3. Reconstruct indexes Optimize access to data file records and recalculate statistics. All the crossed records are automatically deleted.
    4. Rebuild indexes and memos Optimizes the entire data file, its indexes and memos.
    5. Revise and compress indexes and memos Optimize the entire data file, index and memos. The memos will be compressed. Advanced options are available ("Options for compressing the memos").
  • Viewing the properties of a data file
    Displays the characteristics of a data file (name, extension, format, encryption, etc.).
  • Editing and modifying a ".REP" file
    Optimizes the access to the data files.
  • Roll back a transaction or release transaction records
    Rolls back a transaction without interrupting the execution of the program.
Use

Starting WDOptimizer

WDOptimizer can be started in interactive mode via one of the following methods:
  • From WINDEV, WEBDEV or WINDEV Mobile, on the "WDOptimizer" tab, in the "Tools" group, click "Database".
  • Run "WDOptimizer.EXE" directly.
The different operations that can be performed with WDOptimizer are as follows:
  1. Optimizing indexes. For more details, see Index optimization.
  2. View the properties of a data file. This data file can be selected in the list displayed on the screen or it can selected via the file picker.
  3. Editing a .REP file: Simply select the .REP file you wish to edit.. For more details, see Editing and modifying a ".REP" file
  4. Handling transactions. For more details, see Roll back a transaction or release transaction records
Remark: On the development workstation, WDOptimizer can also be launched directly from WDTool.
WDOptimizer can also be run in command line. For more details, see Starting WDOptimizer in a command line.

Use conditions

WDOptimizer can be freely distributed. WDOptimizer can be installed with the applications developed with WINDEV or WEBDEV. The license agreement of WINDEV or WEBDEV is fully enforced.
When creating the setup procedure, WDOptimizer is automatically supplied with your applications.
Reminder: The setup procedure can be created:
  • or from the wizard: under "Project", in the "Generation" group, click on "Setup procedure".
  • from the setup editor: On the "Tools" tab, in the "Utilities" group, click "WDInst".

Required files

The following files are required to install WDOptimizer:
  • WDOptimizer.exe
  • wd300etat.dll
  • wd300hf.dll
  • wd300html.dll
  • wd300mat.dll
  • wd300obj.dll
  • wd300pnt.dll
  • wd300prn.dll
  • wd300sql.dll
  • wd300std.dll
  • wd300vm.dll
  • wd300xml.dll
  • wd300com.dll
  • wd300xtrs.dll
  • WDOutil.WDK
  • WDOptimizer_FR.PDF
  • WDOptimizer_EN.PDF
To uninstall WDOptimizer from a computer, simply delete its directory.
Reminder: Indexing a data file
The index of a data file is a specific file (.NDX). This file is created according to the browse keys defined on the data file. It allows you to quickly find data in a data file.
For a better performance of the searches performed in your data files, the index should be optimized on a regular basis.
Minimum version required
  • Version 9
This page is also available for…
Comments
64 bits
A quand une version 64 bits de WdOptimizer ?
Greg
26 Mar. 2025

Last update: 06/06/2025

Send a report | Local help