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?
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.
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:
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.
Replacing line breaks with spaces.
Set the summary's font size to 1em, which the user can scale as they see fit.
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.
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.
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.
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.
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.
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.
go to post
Unfortunately, we are on 2010.1.
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?
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
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:
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.
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.
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.
go to post
It appears that this is more fielding for your product than needing assistance.
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.
go to post
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.
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.