ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL
  • Overview
  • Configuring the data files (in the data model editor)
  • Using data files exceeding 2 gigabytes
  • Dynamic description of data files
  • WLanguage property
  • Reindexing
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
HFSQL data files exceeding 2 gigabytes
Overview
By default, the HFSQL engine allows you to manage large data files (up to 2 gigabytes).
When the size of a data file (including its index, its full-text index and/or its memo) exceeds 2 gigabytes, a specific configuration is required in the data model editor and in the hardware.
Indeed, to manage data files exceeding 2 gigabytes, you must use:
  • an operating system that supports the files exceeding 4 gigabytes. The following operating systems do not support the files exceeding 4 gigabytes: Windows 98 and Windows Me.
  • A file system that supports the files exceeding 4 gigabytes (NTFS for example in Windows).
Caution: This configuration is required on the computer where the data files are installed and on the computers accessing these data files. Therefore, a computer equipped with Windows 98 cannot access a data file exceeding 2 gigabyte installed on Windows 2000.
Configuring the data files (in the data model editor)
To manage the data files exceeding 2 gigabytes:
  1. Display the description of the requested data file ("Description of data file" from the popup menu).
  2. In the "Details" tab, check "Manage data files exceeding 2 GB (NTFS only)".
Caution: These data files can only be used from a computer equipped with an operating system that supports files exceeding 4 gigabytes.
Using data files exceeding 2 gigabytes

Dynamic description of data files

During the dynamic description of a data file (via the HFSQL properties and HDescribeFile), the management mode of the file size can be configured by HugeFile.

WLanguage property

HugeFileThe HugeFile property is used to configure the maximum size of a data file.

Reindexing

Caution: Reindexing data files exceeding 2 gigabytes can take quite a long time.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/13/2023

Send a report | Local help