Analyze running Caché Routines for efficiency?
Back in my COBOL days, there was a utility that would analyze running COBOL code and expose bottle necks and those modules that were inefficient or were executed multiple times. This was to help the programmer know where to concentrate streamlining efforts.
Is there any such utility for Caché Routines?
There is PERFMON and the Line-By-Line Monitor which you can use to analyze your routines. With PERFMON you can identify the most busy and expensive ROUTINES and you can then analyze a specific routine in detail.
Here are the links to the docs:
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
Hope this helps.
-Michael
^%SYS.MONLBL is a great tool for profiling:
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
Also very helpful if you want to look at the problem from a global centric view rather than a code centric view is ^GLOSTAT:
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
Thank you all for your suggestions.!