ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / Managing HFSQL Client/Server
  • Overview
  • Diagrams
  • Usage example
  • Reading a record
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Operating mode of HFSQL application
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Overview
An HFSQL application can operate in network mode or in Client/Server mode.
To find out which operating mode is adapted to your applications, let's compare these two modes.
In HFSQL Network modeIn HFSQL Client/Server mode
An HFSQL Network application is run on different user computers.An HFSQL Client/Server application is run on different user computers (called client computers).
The data files are found in a directory accessible to the user computers. Each client computer physically accesses the data files.Data files are located on a server. Only the server physically accesses the data files.
Processing (queries, reading/adding to data files, etc.) is carried out on each user workstation.All processing (queries, reading/adding to data files, etc.) is carried out on the server.
Diagrams
Diagram representing the Network mode
Diagram representing the Network mode (WINDEV application)
Client/Server diagram
Diagram representing the Client/Server mode (WINDEV application)
Usage example

Reading a record

  • 1 network access to read the indexes (".NDX" file).
  • 1 network access to read the record (".FIC" file).
  • 1 network access to request the record toward the server.
Note: Each client workstation maintains a cache of record blocks.. Therefore, no new network access is required to read the next records.
In HFSQL Network modeIn HFSQL Client/Server mode
Running a simple selection query:
  • In a simplified manner, as many network accesses as the number of retrieved records (for the index file and the data file).
For example, 500 network accesses if the result of the query contains 1000 records.
  • 1 network access to send the query.
  • 1 network access to retrieve the result of the query.
For example, 500 network accesses if the result of the query contains 2 records.
In HFSQL Network modeIn HFSQL Client/Server mode
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 11/23/2024

Send a report | Local help