InterSystems Caché Reviews & Product Details

I am by no means an expert, but I think it's interesting how Cache is both multidimensional and relational. Though I can't aptly verbalize what impresses me about Cache, after going through training and learning a bit about it I have been impressed. Review collected by and hosted on G2.com.

It's advantages are also its disadvantages. For someone who can't/doesn't focus on this full time it is difficult to master. Due to its low popularity, it is also difficult to find support. Review collected by and hosted on G2.com.

It can handle large volume of data and is robust ; best option for healthcare industry; Review collected by and hosted on G2.com.

Dependency on Healthshare, also an Intersystems product Review collected by and hosted on G2.com.

It seems to perform pretty well based on negligible system resource impact when running large aggregate & join queries. Some queries do take longer than I would expect from a lesser powered SQL server, but I think part of it is process prioritization and limits...because I have yet to break it (make it unresponsive or block other processes) running dumb queries. It also supports native encryption off the shelf, which is now pretty common but for when the version we run was release, there were some major DB products that didn't. The database shadowing and mirroring features built in are reliable and fairly simple to setup, even thought the steps are a little barbaric (shut down database, copy files to target manually to do initial snapshot) Review collected by and hosted on G2.com.

The backup process is rudimentary. We have to create scripts to execute commands to freeze and copy files, then thaw (freeze/thaw is a quiesce). Error message parsing from ODBC connection is sometimes messy. There is an ancient interface required to perform some release tasks. Review collected by and hosted on G2.com.