How to reduce the size of InterSystems Caché database file CACHE.DAT

Question

Question

Nikhil Pawaria · Jan 25, 2019

#Beginner #Databases #System Administration #Caché

How we can reduce the size of cache.dat file? Even after deleting the globals of a particular database from management portal size of its cache.dat file is not reduced.

Discussion (3)0

Log in or sign up to continue

Eduard Lebedyuk · Jan 25, 2019

You need to do these three steps in order:

Compact Globals in a Database (optional)
Compact a Database
Truncate a Database

In can be done via ^DATABASE utility or in management portal.

2 0

score 0 · Answer 1 · 2019-01-25T12:11:40-05:00

This is the way to do it, but make sure you are on a version where this won't cause problems. See:

https://www.intersystems.com/support-learning/support/product-news-alert...

score 0 · Answer 2 · 2019-01-25T02:51:03-05:00

CACHE.DAT or IRIS.DAT, can only grow during normal work. But you can shrink it manually. But it is not as easy as it maybe sounds. And depends on version which you use, only past few versions were added with the compact tool. On very old versions you have to copy data from old database to thew new one.

You can read my articles, about internal structure of CACHE.DAT, just to know what is this inside. And about database with visualization, where you can see how to compact database, and how it actually works.