ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Tools / WDOptimizer
  • Overview
  • WDOptimizer includes multiple modes to optimize indices:
  • How to?
  • Optimizing the indices of a data file
  • Re-indexing options
  • Overview
  • Advanced reindexing mode
  • Options for compressing memos
  • Options
  • Access rights to the data file
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
Overview

WDOptimizer includes multiple modes to optimize indices:

1. Check indices: Checks the consistency between the index and the data files.
2. Recalculate statistics to optimize indices: Optimizes the indices by calculating index statistics. These statistics are used to optimize the filters, the queries and the HFSQL views.
Remark: The more the data file is modified, the less the statistics reflect the content of HFSQL data file. The more records the data file contains, the less the modification of a single record impacts the overall statistics.
3. Rebuild indices: Optimizes the access to the records of the data file and recalculates the statistics. All the crossed records are automatically deleted.
4. Rebuild indices and memos: Optimizes the entire data file, its index and its memos.
5. Check and compress indices and memos: Optimizes the entire data file, its index and its memos. The memos will be compressed. Advanced options are available ("Options for compressing the memos").
Remarks:
  • The data file is recreated: the last writing date of the last record (obtained by HRecordDate) is set to today's date.
  • Timestamp items are also modified and are set to the date and time at which the optimization is performed.
Remarks:
  • Apart from option 2, all the optimization modes lock the data files during the optimization. The users are informed that the data file is currently under maintenance.
  • Once the reindexing is performed, the current HFSQL context is restored (except if the option for compressing memos was chosen).
How to?

Optimizing the indices of a data file

To optimize the indices of a data file:
  1. Start WDOptimizer:
    • From WINDEV, WEBDEV or WINDEV Mobile directly: on the "Tools" tab, in the "Database" group, click "WDOptimizer".
    • run "WDOptimizer.EXE" directly.
  2. Select the data files to process. You can:
    • Drag and Drop the data files from the explorer to WDOptimizer. The dropped files automatically appear in the list.
    • add one or more files via the "Add a file" button.
    • add the data files found in a directory via the "Add a folder" button.
      To process the sub-directories, select "When adding a directory, include the files of all the sub-directories".
  3. Select the data files to process and indicate (if necessary) the password of each data file.
    Remark: If the password is identical for all the data files, check "The password is identical for all the files".
  4. Click the "Optimize indices" or "Optimize indices of selected files" button and choose the desired option.
A report is generated if a problem occurs.
Re-indexing options

Overview

The indexing options are displayed in the lower part of the screen:

Advanced reindexing mode

These options are taken into account for the re-indexing operations from type 1 to type 4:
  • Delete the inactive records (deleted or crossed)
    If this option is selected, the crossed records are permanently deleted.
    Reminder: When a record is crossed, it is deleted logically and it can be retrieved later. The record is still found in the data file. Deleting the crossed records deletes these records permanently and optimizes the size of data file.
  • Delete the damaged records
    If this option is checked, the damaged records are automatically deleted.
  • Reindex without locking the client computers
    If this option is checked, the re-indexing operation is performed in background task and the client applications are not stopped.
    Caution: This option is taken into account for the HFSQL Client/Server data files only.
  • Density of the index
    Corresponds to the density rate of the indices. This rate is set to 80 by default.
    A higher rate increases the density of the index and reduces its size. In this case, the browses, searches, filters and queries are faster. The additions of records and the modifications of records may be slower.
    A smaller rate reduces the density of the index and increases its size. In this case, iterations, searches, filters and queries will be slower. The additions of records and the modifications of records will be faster.
    Caution: this parameter can be used on the data files in HFSQL Classic or Client/Server format only.
  • Character set
    The character set of the data file is kept by default. However, a re-indexing operation can be performed by changing the character set of the data file. In this case, the new character set will be taken into account during the re-index operation. Sorts, searches, ... on string keys (strings, characters, date and time) will be performed according to this character set.

Options for compressing memos

These options are taken into account during the revision with compression of indices and memos (option 5):
  • Keep the crossed records
    If this option is selected, the crossed records are kept. Otherwise, they are permanently deleted.
  • Attempt to retrieve data from the memo if it is damaged
    If this option is selected, WDOptimizer tries to retrieve the memo. Otherwise, the damaged records are retrieved without the associated memo.
    Caution: The memo may not be entirely retrieved. Check your data files.

Options

These options are used to simplify the management of the list of files to re-index:
  • The password is identical for all the files
    If this option is selected, the same password is used for all the data files. All you have to do is specify the password in the "Password" column of the first data file found in the list.
    If this option is unchecked, the password will have to be specified in the "Password" column of the table for each data file.
  • When adding a directory, include the files found in all the sub-directories
    If this option is selected, the data files found in the sub-directories are automatically added.

Access rights to the data file

The optimization triggers the re-creation of the data file on disk.
You must check the rights of the optimized file. These rights can differ from the ones of the source file. In this case, they must be redefined in Windows after the optimization.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/31/2024

Send a report | Local help