Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • How to use HConnectionQuality?
  • Quality level of connection
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
HConnectionQuality (Function)
In french: HQualitéConnexion
HFSQL Client/ServerAvailable only with this kind of connection
Returns the quality level of connection: the higher the level is, the faster the connection will be.
// Checks the quality of connection
// Connection1 is a connection with compression
// Connection2 is a connection without compression
Result1 is int = HConnectionQuality(Connection1)
Result2 is int = HConnectionQuality(Connection2)
IF Result1 > Result2 THEN
Trace("The best connection is Connection1")
Trace("The best connection is Connection2")
<Result> = HConnectionQuality(<Connection>)
<Result>: Integer
Quality level of connection. The higher the level is, the faster the connection will be.
<Connection>: Character string or Connection variable
Connection to test. This connection corresponds to:

How to use HConnectionQuality?

HConnectionQuality can be used with compressed frames.
When should I compress network frames?
The choice must be based on 3 parameters:
  • the speed of the network used,
  • the CPU performance of the client computers
  • the type of the transmitted data.
The importance of each parameter depends on the two other ones so no standard formula is available. However, here are some tips to help you choose:
  • If the speed of the network used is greater than 10 Mbits/second, there is no need to compress the frames.
  • If the network used (GRPS, EDGE or 3G type) is invoiced according to the amount of transmitted data, we advise you to compress the frames in order to reduce the cost.
  • If an important amount of data (binary memo) is transmitted (images, video, zip sound, etc.), the compression of frames will be useless.
  • In all the other cases:
    • on client computers equipped with high-performance processors and if text or text memo data is used by your application, it may be interesting to compress the frames.
    • on client computers equipped with low-performance processors, it may be very interesting to compress the frames if the transfer rate is quite slow.
    It may be interesting to perform comparative measurements by using the performance analyzer.
HConnectionQuality can be used to compare the performance of a compressed and an uncompressed connection.

Quality level of connection

The quality level of the connection depends on several aspects, for example:
  • The CPU workload of the client and server.
  • The use of network resources by other programs.
  • The workload on the network devices (switch, router, etc.).
Component: wd280hf.dll
Minimum version required
  • Version 14
This page is also available for…
Click [Add] to post a comment

Last update: 08/30/2022

Send a report | Local help