PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
  • Equivalence
  • Retrieving the records
  • Management of the Property CacheSize
  • hQueryWithoutCorrection constant
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
CacheSize (Property)
In french: TailleCache
OLE DBNative Connectors (Native Accesses)Available only with these kinds of connection
The Property SizeCache makes it possible to:
  • Know the maximum number of records that can be contained in the Native Connector MySQL cache.
  • Modify the maximum number of records that can be contained in the Native Connector MySQL cache. In this case, if the connection is currently opened, it will be closed and reopened with the new parameters during the first access to a file that uses this connection.
Remark: The connection can correspond to:
Example
WINDEVWEBDEV - Server codeAjaxOLE DBNative Connectors (Native Accesses)
// Modify the cache size of the Native Connector MySQL used by
// MyConnection
MyConnection.CacheSize = 450
Syntax

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

<Cache size> = <Connection used>.CacheSize
<Cache size>: Integer
Size of the Native Connector MySQL cache.
If this parameter corresponds to:
  • -2: the cache size is the size per Default (100 for the Native Connector MySQL).
  • -1: the size of cache is unlimited.
  • 0: the cache stores no record. No record is retrieved.
<Connection used>: Character string (with or without quotes) or Connection variable
Name of connection used. This name was defined:

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

<Connection used>.CacheSize = <Cache size>
<Connection used>: Character string (with or without quotes) or Connection variable
Name of connection used. This name was defined:
<Cache size>: Integer
New cache size for Native Connector MySQL.
If this parameter corresponds to:
  • -2: the cache size will be the size by Default (100 for the Native Connector MySQL).
  • -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. It is advisable to use the Property 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.
WINDEVWEBDEV - Server codeReports and QueriesAjaxOLE DBNative Connectors (Native Accesses)

Management of the Property CacheSize

The Property CacheSize is managed only by the Native Connector MySQL.
The other Native Connectors s do not manage the CacheSizeproperty. . 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 cannot be modified with the Property CacheSize.
See also
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment