SET TABLE CACHE PRIORITY
SET TABLE CACHE PRIORITY ( aTable ; priority )
| Parameter | Type | Description | |
|---|---|---|---|
| aTable | Table | 🡒 | Table whose scalar data priority value has to be set for the session |
| priority | Longint | 🡒 | Cache priority value for scalar values in the table |
Expert mode
This command is reserved for specific needs. It must be used with care since it can affect database performance.
Description
The SET TABLE CACHE PRIORITY command sets a specific priority to the data related to aTable in cache for all processes in the current session. This command should be called in the On Startup or On Server Startup database method.
Note: This command only works in local mode (4D Server and 4D); it cannot be used in 4D remote mode.
This command handles priority for data in scalar fields only (date, number, or string types). Priority for fields of binary type (Blobs, texts, pictures, and objects) is handled by the SET BLOBS CACHE PRIORITY command.
In the priority parameter, pass one of the following constants from the "Cache Management" theme:
| Constant | Comment |
|---|---|
| Cache priority low | |
| Cache priority very low | |
| Cache priority normal | Sets the cache priority to its default value |
| Cache priority high | |
| Cache priority very high |
Example
In the , you want to set a high priority for the [Customer] scalar data:
SET TABLE CACHE PRIORITY([Customer];Cache priority very high)
See also
ADJUST INDEX CACHE PRIORITY
ADJUST TABLE CACHE PRIORITY
Get adjusted table cache priority