ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • How to use HConnectionQuality?
  • Quality level of connection
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
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.
Example
// Checks the connection quality
// Connection1 is a connection with compression
// Connection2 is a connection without compression
Result1 is 8-byte int = HConnectionQuality(Connection1)
Result2 is 8-byte int = HConnectionQuality(Connection2)
IF Result1 > Result2 THEN
Trace("The best connection is Connection1")
ELSE
Trace("The best connection is Connection2")
END
Syntax
<Result> = HConnectionQuality(<Connection>)
<Result>: 8-byte 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:
Remarks

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 costs.
  • If a large amount of data (binary memo) is transmitted (images, video, audio, zip, etc.), the compression of frames will have little effect.
  • In all the other cases:
    • on client computers with high-performance processors and if your application uses text or text memo data, it may be useful to compress the frames.
    • on client computers with less powerful processors, the lower the transfer speed, the more useful the compression.
    You will need to compare different aspects using the Performance profiler.
HConnectionQuality can be used to compare the performance of a compressed and an decompressed 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: wd290hf.dll
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/08/2023

Send a report | Local help