Why change?
I have already asked a question about migrating an Oracle database to Caché, and I was promptly answered. Now, I have one more question, however it is more conceptual. In general, any tool defends its benefits, and looking at Caché's, among many, there is a lot of talk about speed. The question is, if I already have a database, and at the moment, its performance is not a problem, I would like to know what else could influence the change of this database? Remembering that it is functional and without any apparent problem.
Besides the functionality and speed that you mentioned already,
there come other factors to my mind. Just a few from the hip:
As I mentioned already in a different place: The only limit is your own imagination.
When I describe InterSystems IRIS, I always start with how it is a multimodel DBMS at its core.
In my opinion that is its main advantage (on the DBMS side). And the data is stored only once. You just choose the access API you want to use.
More about multi-model approach of InterSystems IRIS.
But InterSystems IRIS is not only a DBMS, there are a lot of features, including: