CacheSize (Property)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Retrieving the records

Managing the ..CacheSize property

hQueryWithoutCorrection constant

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

Equivalence
Retrieving the records
Managing the ..CacheSize property
hQueryWithoutCorrection constant

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HFSQL properties

CacheSize (Property)

In french: TailleCache

Available only with these kinds of connection

..CacheSize is used to:

Find out the maximum number of records that can be stored in the cache of Native MySQL Access.
Modify the maximum number of records that can be stored in the cache of Native MySQL Access. In this case, if the connection is currently opened, it will be closed and re-opened with the new parameters during the first access to a file that is using this connection.

Remark: The connection can correspond to:

a connection described in the data model editor,
a connection described by HConnect, HDescribeConnection or HOpenConnection.
a connection described by a Connection variable.

Example

// Modify the size of the cache for the Native MySQL Access used by
// MyConnection
MyConnection..CacheSize = 450

Syntax

Finding out the size of the cache for a connection Hide the details

<Cache size> = <Connection name>..CacheSize

<Cache size>: Integer

Size of the cache for the Native MySQL Access.
If this parameter corresponds to:
-2: the size of the cache is the default size (100 for the Native MySQL Access).
-1: the size of cache is unlimited.
0: the cache stores no record. No record is retrieved.

<Connection name>: Character string (with or without quotes)

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by the Connection type.

Defining the size of the cache for a connection Hide the details

<Connection name>..CacheSize = <Cache size>

<Connection name>: Character string (with or without quotes)

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by the Connection type.

<Cache size>: Integer

New size of the cache for the Native MySQL Access.
If this parameter corresponds to:
-2: the size of the cache will be the default size (100 for the Native MySQL Access).
-1: the size of the cache will be unlimited.
0: the cache will store no record. No record will be retrieved.

Remarks

Equivalence

..CtCacheSize is used to define the size of the cache for a MySQL connection. This property is kept for backward compatibility. We recommend that you use ..CacheSize.

Retrieving the records

The speed at which the entire set of records is retrieved is proportional to the size of the cache: the larger the cache size, the faster the records are retrieved.

However, the smaller the cache size, the faster the first record will be read.

Caution: The memory used by the cache is proportional to the size of the cache.

Managing the ..CacheSize property

..CacheSize is supported by the Native MySQL Access only.

The other native accesses do not support ..CacheSize. In this case, the use of this property will be ignored and no error will be generated.

hQueryWithoutCorrection constant

If the query is run while no check is performed on the SQL code (hQueryWithoutCorrection constant): the size will be unlimited and it will not be modified by ..CacheSize.