ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
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
HSetCache (Function)
In french: HGèreCache
HFSQL Client/ServerAvailable only with this kind of connection
Used to configure the management of caches in the HFSQL Client/Server engine.
Example
HSetCache(hPageSize, 2000)
Syntax
<Result> = HSetCache(<Parameter to modify> [, <Data file> [, <Item>]] , <Value>)
<Result>: Integer
Former value of modified parameter (value before modification).
<Parameter to modify>: Constant
Parameter of the cache to modify:
hPageSizeSize of a block of caches. This block of caches will be used when browsing a data file.
A large block of caches improves the browse and increases the transfers via network and the memory consumption.
This parameter corresponds to the number of records read during the browse.
<Data file>: Optional character string
Name of the data file to which the modification must be applied.
If this parameter is not specified, the modification is applied to all the data files.
<Item>: Optional character string
Name of the item to which the modification must be applied.
If this parameter is not specified, the modification will be applied to all the items found in the specified data file.
<Value>: Integer
New value that must be given to the parameter.
For the hPageSize constant, this value must be between 1 and 5000 (the default value on a PC is 1000 and on a mobile is 10).
Business / UI classification: Business Logic
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/07/2023

Send a report | Local help