Cache
Cache is a fast memory storage that stores data to enable quicker access to these data in the future. In computing, cache is often used to store frequently accessed data to reduce access time and increase system efficiency.
The panel Cache allows reading system settings for company.
The functionality is accessed on panel Performance in Administration panel.
The following is a description of the functionality of the form.
| Owner |
SQL Query Fields. |
| Groups |
Number of active groups. |
| Cache (queries) |
Shows cached queries. The number of queries increases with repeatable queries. |
| Database (queries) |
Cached database queries. |
| Objects in Use |
The number of objects that were created from queries on the database and are valid. |
| Expired Objects |
Objects that have exceeded their time validity. |
| Trash |
Invalid objects due to database changes. |
| Refresh |
Update the Cache Statistich table. |
| Auto-Refresh |
There is written the number of Auto-Refresh.
 |
WARNING
Auto-refresh - Cache statistics stop if the focus is on the grid.
|
|
| Single Object (c) |
Determining the time validity of an individual object and the time interval of checking on the database. Determines how long objects are valid. Each access to the object sets a start time that determines the validity.
|
WARNING
- If the Single Object setting is set to 0 (zero), the program will run without a cache.
- Writing to the database is immediate. The cache only works on read data.
|
|
|
No. of Object (c)
|
Determining the time validity of an individual object and the time interval of checking on the database. No. of objects for validation.
|
|
Remove Optimizations
|
After confirming the warning, it removes all optimizations and all cache objects. |
| Clear All |
Removes all cache objects. |
| Clear Objects in Use |
Removes all valid objects. |
| Clear Expired |
Removes all expired objects. |
| Clear Trash |
Remove any objects that are not valid.
|
| Max. Connections |
There is written the number of maximum connections. |
| Stop |
Stoped running processes. Beside the button is written the number of processes running
|
WARNING
When you stopped, this may cause data errors.
|
|
|
WARNING
Cache operation is automatically disabled while the following forms are open:
- editing ARES procedures;
- editing reports.
|