ADJUST TABLE CACHE PRIORITY
ADJUST TABLE CACHE PRIORITY ( aTable ; priority )
| Parameter | Type | Description | |
|---|---|---|---|
| aTable | Table | → | Table whose scalar data priority value has to be adjusted |
| priority | Integer | → | Cache priority value for 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 ADJUST TABLE CACHE PRIORITY command modifies the priority value of the data related to aTable in cache for the current process. A call to this command replaces any priority value previously adjusted through the same command in the same process. This command adjusts the priority for a temporary need, for example during a query or an import.
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 ADJUST 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
You want to temporarily change the cache priority for the [Docs] scalar fields:
ADJUST TABLE CACHE PRIORITY([Docs];Cache priority low)
// ... do some specific operation
ADJUST TABLE CACHE PRIORITY([Docs];Cache priority normal)