PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • WDOptimizer
  • Use
  • Starting WDOptimizer
  • Use conditions
  • Necessary files
  • Reminder: Index of a file
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
Overview

WDOptimizer

The different operations that can be performed by WDOptimizer are as follows:
  • Optimizing the indexes
    This option allows you to perform several types of operations:
    1. Check the indexes: Checks the consistency between the index and the data files.
    2. Optimize the speed of indexes (Re-calculate the statistics): Optimizes the indexes by calculating statistics on the indexes. 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 HFSQL data file. The more records the data file contains, the less the modification of a single record impacts the overall statistics.
    3. Rebuild the indexes: Optimizes the access to the records of the data file and re-calculates the statistics. All the crossed records are automatically deleted.
    4. Rebuild the indexes and the memos: Optimizes the entire data file, its index and its memos.
    5. Check and compress the indexes and the 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").
  • View the properties of a file
    Displays the characteristics of a data file (name, extension, format, encryption, ...).
  • Edit and modify a ".REP" file
    Optimizes the access to the data files.
  • Cancel a transaction or free the records in transaction
    Cancels a transaction without interrupting the execution of the program.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Use

Starting WDOptimizer

WDOptimizer can be started in interactive mode via one of the following methods:
  • From WINDEV, WEBDEV or WINDEV Mobile, select "Tools .. WDOptimizer - HyperFileSQL Optimizer".From WINDEV, WEBDEV or WINDEV Mobile, on the "Tools" pane, in the "Database" group, click "WDOptimizer".
  • Run "WDOptimizer.EXE" directly.
The different operations that can be performed by WDOptimizer are as follows:
  1. Optimizing the indexes. See Optimizing the indexes for more details.
  2. Viewing the properties of a 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: All you have to do is select the requested .REP file. See Editing and modifying a ".REP" file for more details
  4. Handling the transactions. See Canceling a transaction or freeing the records in transaction for more details
Note: On the development computer, WDOptimizer can be started from WDTool directly.
WDOptimizer can also be run in command line. See Starting WDOptimizer in command line for more details.

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 from the wizard ("Workshop .. Create the setup procedure") or from the setup editor ("Tools .. WDInst - Setup editor").Reminder: The setup procedure can be created:
  • from the wizard: on the "Project" pane, in the "Generation" group, click "Setup procedure".
  • from the setup editor: on the "Tools" pane, in the "Utilities" group, click "WDInst".

Necessary files

The following files are required to install WDOptimizer:
  • WDOptimizer.exe
  • wdxxxetat.dll
  • wdxxxhf.dll
  • wdxxxhtml.dll
  • wdxxximg.dll
  • wdxxxmat.dll
  • wdxxxobj.dll
  • wdxxxpnt.dll
  • wdxxxprn.dll
  • wdxxxsql.dll
  • wdxxxstd.dll
  • wdxxxvm.dll
  • wdxxxxml.dll
  • WDxxxOutil.WDKWDOutil.WDK
  • WDOptimiseur.CHM
  • WDOptimiseurUS.CHM
To uninstall WDOptimizer from a computer, all you have to do is erase its directory.
Reminder: Index of a file
The index of a data file is a specific file (.NDX). This file is created according to the search 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 required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment