ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / Managing HFSQL Client/Server
  • Overview
  • Diagrams
  • Usage example
  • Reading a record
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
Operating mode of HFSQL application
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Overview
A 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
A HFSQL Network application is run on different user computers.A 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.
The processes (queries, read/add operation in a data file, ...) are performed on each user computer.All the processes (queries, read/add operations in a data file, ...) are performed 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.
Remark: Each client computer maintains a cache containing blocks of records. 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 query result 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 query result 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: 06/25/2024

Send a report | Local help