ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • How to use the <Connection variable>.ConnectionQuality function?
  • 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
<Connection variable>.ConnectionQuality (Function)
In french: <Variable Connexion>.Qualité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
// Teste la qualité de la connexion
// Connexion1 est une connexion avec compression
// Connexion2 est une connexion sans compression
Connexion1 is Connection
Connexion2 is Connection

Résultat1 is 8-byte int = Connexion1.QualitéConnexion()
Résultat2 is 8-byte int = Connexion2.QualitéConnexion()
IF Résultat1 > Résultat2 THEN
	Trace("La meilleure connexion est Connexion1")
ELSE
	Trace("La meilleure connexion est Connexion2")
END
Syntax
<Result> = <Connection>.ConnectionQuality()
<Result>: 8-byte integer
Quality level of connection. The higher the level is, the faster the connection will be.
<Connection>: Connection variable
Name of the Connection variable that describes the connection to test.
Remarks

How to use the <Connection variable>.ConnectionQuality function?

<Connection variable>.ConnectionQuality 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.
<Connection variable>.ConnectionQuality 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: wd300hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 08/24/2023

Send a report | Local help