The 4D v16 version has definitely been designed for better performance and scalability. In addition to major features like preemptive multi-threading, 4D v16 64-bit is embedding a brand new cache manager for a optimized handling of objects in cache memory avoiding any fragmentation issues.
The new cache manager improves the usage of very large cache for modern computers (with 64 or even 128 GB of Cache) allowing to take advantage of low RAM prices to have even large databases fully in memory. It also improves the situation of small cache size with very large data files, by decreasing the amount of unloading memory with increased support of priorities for data objects to be hold or released from cache.
As a result large database will be faster, allowing more data and more parallel user access.
While the new feature is designed for zero administration and running fully automatically, for fine tuning and data analysis, we have added 3 new commands to provide you with more programmatic capabilities:
- The SET CACHE SIZE command allows to expand or reduce the cache size on the fly, and also to define the minimum number of bytes required before starting to free objects from cache memory.
- The Get cache size command returns the current cache size
- The Cache info command returns detailed information about the current cache contents (used memory, loaded tables and indexes, etc.) in a C_OBJECT, allowing introspection and statistics.
To learn more about the new commands, download our example:
For more details, please refer to the Cache Management article in the 4D v16 documentation.