ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
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
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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 handles files larger than 4 Gigabytes. The following systems do not support files larger than 4 Giga: Windows 98 and Windows Me.
  • A file system that supports the files exceeding 4 gigabytes (NTFS for example in Windows).
Attention: This configuration is necessary both on the workstation where the data files are installed and on workstations 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 desired data file ("Data file description" option in the context menu).
  2. On the "Compatibility" tab, check "Support files larger than 2 GB (recommended for operating systems later than Windows 2000 or Linux Ext2)".
  3. Confirm.
Warning These data files can only be used from a workstation running an operating system that supports files larger than 4 Giga.
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 sets the maximum possible size of a data file.

Reindexing

Caution: Re-indexing data files over 2 Gigabytes in size can take a long time.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/06/2024

Send a report | Local help