Using the HyperFileSQL logs, you can figure out which queries are used the most and which queries take a long time to run. These queries should be optimized.

To optimize a query, WinDev offers a query optimizer, accessible via the "Project .. Performances and enhancements .. Optimize the project queries" menu option.

The query optimizer lets you see in just a few click whether you need to add key items to the various data files in order to optimize the queries' execution.
Simply select the queries to check and click the "Run the performance analysis" button. WinDev displays the keys to add to the data files to optimize the queries then.
If the optimizer detected some missing keys, simply click the "Apply all modifications" button and WinDev will automatically create the needed keys.
Then, simply regenerate the analysis with the automatic data file modification option.

Note:
When a query is created, WinDev automatically performs this performance analysis. If an optimization is possible, an AAD (Aided Application Development) suggestion will be displayed in the query editor.

A large number of tools come with SCM to performed advanced operations. One of the indispensable tool is the management of source differences.

This feature allows developers to see the source differences between two versions of an element (a window, a class, etc.) and if needed to merge the source code to apply a correction for instance.

History
To do so, simply access the element's history accessible via the "SCM..Element history" menu. From this window the developer can access all the versions of the element since it was created. Next to each version there is a comment. These comments are the ones entered by developers when checking in the element into SCM.

Note:
You can force comments to be entered by defining a "check-in policy" from the SCM explorer. This feature is described later in this article.

Retrieving and merging
Using the history, you can restore the element as it was at a previous date.
There are several ways you can retrieve an element:
• retrieve the entire element. That is all the whole element (a window for instance).

To retrieve the entire element, simply select the version to retrieve and click the "Get" button.
This option is only interesting if the element has not evolved a lot. This is because if changes have been made, they are overwritten.

• retrieve only the piece of code you want. Simply click the "Compare" button.
in this case, WinDev calculates the differences between the current version of the element and the version selected in the history.
The developer then sees all the differences between the two elements (code and interface differences).

When clicking the eye icon, the developer is shown both pieces of code side by side
• on the left the code of the current element,
• on the right the code of the element in the history.

You can then retrieve part of the code using the arrow keys located next to each detected difference.

The statistics on server use are accessible from the HyperFileSQL Control Center. Simply select the database you want and access the "Log and Statistics" tab. From this tab, you can access the server's logs and activity statistics.

Server logs
The server logs contain information about the calls to the server, i.e. about the requests sent by the applications.
Logs allow you to monitor applications that use a HyperFileSQL server. For example, you can detect queries that are run an abnormal number of times, queries that take too long ...

Activity statistics
The activity statistics provide information about the HyperFileSQL server machine. For instance, the amount of information sent through the network, the amount of information read from the disk...
The activity statistics allow you to see whether the server is properly configured to support its loads: is the network card fast enough, are the disks fast enough, ...

Activation
The logs and statistics are enabled and configured in the "Configuration" tab of the HyperFileSQL Control Center.

To enable the logs, simply:
• select "Logs",
• check the "Enable the backup of the calls to the server in the log file" box. When selecting this option, all the calls to the server are stored along with the function that made the call (for example, HExecuteQuery or HReadSeek).

You can also store all the parameters of the calls to get an even more detailed log. To find out which query has been executed for example, the query parameters ...

To enable activity statistics, simply:
• select "Activity statistics",
• check "Enable the activity statistics of the server".

Note:
In order for the modifications to be taken into account, you need to click the "Apply" button.

Once the execution log have been enabled, you can display
• the most used queries,
• the longest queries,
• the longest function calls,
• the applications that consume the most,
• all the logs.

Simply select the information to display and the start and end dates you want, then click the "Display" button.