PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
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 ("Structure of files .. Description").Display the description of the requested data file ("Description of data file" from the popup menu).
  2. In the "Details" tab, check "Manage the data files exceeding 2GB".
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

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