PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Diagrams
  • Use examples
  • Reading a record
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
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.
A HFSQL Network application is run on different user computers.A HFSQL Client/Server application is run on different user computers (called client computers).
In HFSQL Network modeIn HFSQL Client/Server mode
The data files are found in a directory accessible to the user computers. Each user computer physically accesses the data files.The data files are found 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
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Diagrams
Diagram representing the Network mode
Diagram representing the Network mode (WINDEV application)
Diagram representing the Client/Server mode
Diagram representing the Client/Server mode (WINDEV application)
Use examples

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 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 required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment