All
Accepted answers
Mack Altman · Aug 28, 2017 go to post

This did end up being custom code. Since it was written to the cconsole.log, my assumption was that it was native.

Mack Altman · Aug 22, 2017 go to post

Currently, we are running 2010.2 and I am following this to review our performance. In doing so, I read above, "The maximum size of routine buffers is 1023 MBs."

I was wondering if you could clarify what this means as I'm finding that the maximum is 65,535.

Thanks in advance.

Mack Altman · Aug 15, 2017 go to post

The following is the capture requested with the exception of the fields that were trimmed due to them all being 0. The fields trimmed were RemGrefs, GRratio, RemGupds, RemRrefs, RemRLaS, GblSz, pGblAsz, RouSz, pRouAsz, ObjSz, pObjAsz, ActECP, Addblk, PrgBufL, PrgSrvR, BytSnt, BytRcd, and IJULock.

mgstat-capture

Mack Altman · Jan 30, 2017 go to post

This does work for intermediate routines; however, it didn't seem to work with MAC routines. Do you know of a method for making changes to the MAC routines?

Mack Altman · Jan 23, 2017 go to post

Thanks for the response; however, I am trying to determine our rate of consumption, which we would need to know the formula for the consumption of storage and not for what has already been consumed.

Mack Altman · Jan 23, 2017 go to post

This does not identify how consumption may be calculated; however, it does advise how we can determine how much storage a global has already consumed. I am looking for how to calculate consumption, which would help us in identifying our personal rate of consumption.

EDIT: It may be worth noting that when reviewing a global with this class the output was 0.008 for multiple tests, where ^%GSIZE provided varying bytes for each test.

Mack Altman · Dec 28, 2016 go to post

Due to receiving the Zen .js errors, I was unable to use the Global Mappings page; however, I was able to change the Default Database for Globals to BetaDB and then use the following to provide the solution.

%SYS>s Properties("Database")="AlphaDB", Status=##Class(Config.MapGlobals).Create("Alpha","Customers(BEGIN):(10000001)",.Properties)
Mack Altman · Dec 28, 2016 go to post

Yes. However, I'm not showing where in the documentation, or in the link you've provided, it showing what I've asked.

I'm not sure how efficient it would be to place 10M references in the global mappings.

Are you seeing something in the referenced link that addresses the issue discussed?

Mack Altman · Dec 2, 2016 go to post

I ran TuneTable on one table and it seemed rather quick. Following that I used the 'TuneTables' option and its been running in the background for about 2 hours now.

There isn't much available in the 2010.2 docbook about it. Are there any best practices to running it?

Mack Altman · Dec 2, 2016 go to post

The class referencing the account global doesn't even finish a COUNT (ex. SELECT COUNT(acctID) FROM namespace.account). The global itself looks like the following, which have multiple parent and child nodes as well as varying numbers of positions for each. I've posted the structure below.

global(acctID,parent):positions|child:positions|...

account(acctID,10):25|1:12|2:37|3:35|4:30|5:7|6:28|7:21|8:17
account(acctID,12):71|1:9|2:18|3:4|4:8|5:18|6:2|7:2|8:8|9:16|10:12
account(acctID,16):28|1:13|2:46|3:7|4:8
account(acctID,20):7|1:85|2:49|3:28|4:8|5:14|6:4|7:13|8:35|9:2
account(acctID,27):45|1:13|2:40|3:40|4:1
account(acctID,30):13|1:5|2:22|3:22|4:22|6:28|7:12|8:10|9:3|10:3|11:5|12:22
account(acctID,31):16|1:2|2:2|3:38|4:35|5:7|6:1|7:45|8:10|9:10
account(acctID,40):42|1:44|2:11|3:12
account(acctID,50):79|1:50|2:14|3:48|4:20
account(acctID,60):19|1:24|2:10|3:20|4:24|5:24
account(acctID,70):7|1:32|2:9|3:9|4:23|5:15|6:10|7:8|8:6
account(acctID,90):1|1:9|2:9|3:10|4:10|5:15|6:12|7:5|8:4|9:4|10:4|11:13|12:3|13:5|14:22|15:22|16:22|17:5|18:13
 

Mack Altman · Oct 13, 2016 go to post

I apologize for not speaking more specifically. I am speaking to the results page for search and tags pages. In other words, when you are provided multiple posts/questions at once.

The easiest way to simulate this is to click on "Caché" from the BROWSE BY TAG side-bar and review the results provided.

Many users "greet" the reader in the first few lines. This requires you to visit the page to "view a summary" rather than using the query page to pull this information.

After reviewing several, I'd recommend the following on the results page:

  1. Removing any WYSIWYG formatting that was done on the post. Although appropriate for the individual post, you'll find that many are screaming their header.
  2. Replacing line breaks with spaces.
  3. Set the summary's font size to 1em, which the user can scale as they see fit.
Mack Altman · Oct 13, 2016 go to post

Comments are included at varying levels as they compile down.

This is due to it reviewing Macro Routines ("MAC"). If you were to review Intermediate Routines ("INT"), you would rule out some; however, there are still comments that are included within INT routines.

Mack Altman · Oct 11, 2016 go to post

It's not that people are lazy, as much as it is unaware of how to type an é on an English keyboard.

Some would say poor marketing played a role here as it is quite difficult to search for Caché information due to search engines grouping the results with cache.

Mack Altman · Oct 11, 2016 go to post

In regards to Google Groups, I removed the post (or at least its not showing for me there any longer).

If its possible, how do we go about doing it?

As far as legality, this would be situational and in our case irrelevant. We are looking at pulling an old backed up .obj to identify how an older developer of ours had done it. Unfortunately, the .int was not backed up.

Mack Altman · Oct 11, 2016 go to post

It appears that this is more fielding for your product than needing assistance.

Mack Altman · Oct 11, 2016 go to post

Lisa,

This is a forum for InterSystems. This is not a forum for Ontario Systems. If you would like assistance with an application, you should refer to the developer of that application. While the application may run on a Caché database, the specifics of an application would not be supported by the developers of the database the application's developers choose to use.

In other words, your FACS question should not be asked here.

Mack Altman · May 26, 2016 go to post

 

While I'm not experienced with CSP/ZEN, I thought I'd make a suggestion from an outsider's perspective. As we all know, server-side does the work and client-side does the tidying up. So, let's keep things simple. I see your current situation is as follows.
 
Back-End Issue
You need to know a CSP/Zen Mojo approach to including code.
 
Front-End Issue
You are unsure how to create a fixed header with a navbar; and sticky footer in Bootstrap.
 
Back-End Solution
 
In PHP, this is usually obtained with includes. However, CSP does this in a similar fashion through the include directive (#INCLUDE), which you can find more info here: http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…. Also, any client-side changes you'd want to be done with JS so that unnecessary load isn't placed on the server.
 
Front-End Solution
The front-end should be simple. There's lots of articles on how to use Bootstrap to achieve this. Here's on example: http://getbootstrap.com/examples/sticky-footer-navbar. Be sure you are using a CDN to maximize the load time for the client.
Mack Altman · May 26, 2016 go to post

The IP address was the same coming from both servers. I did this to ensure this wasn't an issue.

In regards to the TLS, this is required.

Mack Altman · Jan 10, 2016 go to post

This is definitely something that the community, and InterSystems, needed. Since the language is not taught in schools, rarely used, and hidden as it's the backbone of some major applications, many developers, like myself, are not, if ever, usually introduced to it.

When I began, I was told its sort of like C and nothing like PHP/JS, but I needed to develop a payment application for a website that integrated with the DB. After lots of trial and error, reading high-level (understandable, but quite difficulty when never exposed to it) technical documents, and time, I did produce the application. Since, I've enjoyed the power it has, but wished the community was larger.

I am glad to see learning opportunities becoming available to increase its exposure and the community. The more people apart of our community, the quicker we expand and develop things for our IoT and Big Data issues.