Home | Sign in | English EN

  • Overview
  • Benefits of optimization
  • Optimization
  • General points
  • The views
  • Queries
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
Optimizing the remote access
The "Remote access" feature is kept for backward compatibility. It is recommended to use an HFSQL Client/Server database to remotely access an HFSQL database.
The remote access allows you to consult an HFSQL database via Internet/Intranet or via STN (Switched Telephone Network).
This help page explains how to optimize the remote access (RPC on HFSQL).
On slow networks, the performance deteriorates as the number of exchanges increases between the different computers.
To improve the performance, some modifications must be performed in the programs and/or data. These modifications consist in reducing the number of exchanges between the different computers.
A program performs a search on 50 000 records. When reading the 50 000 records with the HFSQL browse functions (HReadNext, HReadFirst, ...), 50 000 round-trips are required to bring the information back to the application.
On a slow network or over phone lines (RTC), this method for reading records is penalizing.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Benefits of optimization
Optimizing the remote access is essential in case of slow networks (LAN, RTC, ...). The optimization consists in reducing the number of exchanges. Therefore, the processes are faster and the access to data is improved.

General points

To optimize the remote access (RPC) on HFSQL, we advise you to:
  • use the following functions to find or browse records:
  • call HExecuteView, HCreateView for using the views.
  • call HExecuteQuery for using the queries.
  • associate the controls displaying data (Table, List Box and Combo Box controls) with queries (instead data files).
  • if you are not using the memo items, call HSetMemo to disable the management of memos (hMemoNo constant).

The views

An HFSQL view corresponds to a "memory image" of a data file. It is handled like a standard data file.
When creating the view (HCreateView), you have the ability to specify the number of records to return whenever a browse function is called (<Page Size> parameter in HCreateView).
The number of round-trips between the remote computers is limited. Therefore, the views should be used when you are handling a single file.


A query is used to request information from a database to view, insert, change or delete data. The query structure defines the data used. For more details, see What is a query?
The queries are used to select data coming from one or more data files. To optimize the queries, use HOptimize on the base files of query.
To take into account the modifications performed on the query result, use HExecuteQuery associated with the hModifyFile constant.
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment