Why not Cache from Intersystems?

I have some experience with a very large OLTP system that is 7+ TB in size and performs very well for 30K+ concurrent users. It is built using Intersystems Cache based on the very old but very scalable MUMPS platform. Why don't I see more discussions about archiectures such as these in this forum? I am curious why this platform scales so much better then the typical RDBMS.

Todd Hoff's picture

Re: Why not Cache from Intersystems?

> Why don't I see more discussions about archiectures such as these in this forum?

I just haven't yet run across any websites that use this solution. Please email me and then maybe we can do a profile?

thanx

Re: Why not Cache from Intersystems?

Because it doesn't line up with LAMP architecture? It's a proprietary solution that isn't supported by the skill sets of most practitioners. One of the factors in any architecture decision has to be: do we have the skills to use this? If not, is the value of it sufficiently high to pay to learn it? The latter question is a hard barrier to get over, particularly if you have mainstream skills and the technology is fairly inaccessible or proprietary. And how about people who know how to troubleshoot or support it?

The difference between having a deep skill set and a shallow skill set can be the difference between success and failure. Any project can be done in any pretty much any technology (Turing) but doing it well and quickly is life and death. Also, the inability to find people who know an unusual skill or who are willing to sidetrack their careers, and resumes, can kill a project in even the greatest of new technologies. Sometimes it's just better to go with what you know.

Then there's cost. What can beat MySQL for cost?

Re: Why not Cache from Intersystems?

I've been wondering why ODBMSs haven't been discussed more as well. It's funny. You have all these different frameworks (Active Record, Hibernate, etc) that fake an ODBMS through a persistance layer. Why not just use an ODBMS?

Having been working in an IT department driven by Accounting (CFO/CTO combined into one position), Reporting is what drives all of this. Specifically, user generated reports through Crystal reports, Excell, etc. There's a misconception that you have an ODBMS or an RDBMS and that you'll experience a heavy hit when using the RDBMS facade of an ODBMS (Perception, no idea if it's true). That, and users still think of data as flat and, when you think of how data is pulled from an RDBMS, it is flat.

ODBMSs add a true heirarchy to the representation.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd><div ?=?><p ?=?> <img ?=?><h1 ?=?><h2 ?=?><h3 ?=?>
  • Lines and paragraphs break automatically.
  • Glossary terms will be automatically marked with links to their descriptions
  • You may link to webpages through the weblinks registry

More information about formatting options

To combat spam, please enter the code in the image.