Boost your performance with the new cache manager

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:

Example Database


For more details, please refer to the Cache Management article in the 4D v16 documentation.

Caroline Briaud
• 4D Product Team Leader •Caroline joined 4D SAS in July, 2013 as an Engineering Manager responsible for new features definition. Caroline helped the Engineering team to put in place the R-release concept, with the new development process definition and its application within 4D’s engineering teams.Caroline is now leading the 4D Product team, mainly made up of Product Owners which are representing the customers within Engineering.Caroline started her career as a software developer in the mobile phone industry. She specialized in program management with an American company in an international context spread across US, India and China.