I'm deeply impressed.
should have seen this earlier.
- Log in to post comments
All
Accepted answers
pls. add some details on Caché version & os
- Log in to post comments
thx.
so you confirmed to me that it was't just wishful thinking 
- Log in to post comments
definitely a good idea to run routine ^%GSIZE to find the big consumers and packingdirectory: c:\intersystems\cache\mgr\user\
Page: 1 GLOBAL SIZE 08 Aug 2017
10:28 AM
Global Blocks Bytes Used Packing Contig.
-------- -------- --------------- ------- -------
CacheStd 1 140 2 % 0
CacheStdS 1 92 1 % 0
CacheStream 109 764.376 86 % 70
ERRORS 1 12 0 % 0
G1 1 72 1 % 0
- Log in to post comments
you are right on %objlasterror. and that's how I work it around
but if you want to keep a log and chase sporadic error events this is quite an extra effort.
- Log in to post comments
develop on prod ? 
- Log in to post comments
So we are back to Documentation vs. Reality.
And another excellent example for the importance of this community.
- Log in to post comments
I was waiting for it.
And I missed this setup in other places.
- Log in to post comments
Check win version against version supported by Caché first.
http://docs.intersystems.com/cache20141/csp/docbook/DocBook.UI.Page.cls…
- Log in to post comments
It's not yet time for GBLOCKCOPY.
In namespace %SYS you should find a routine ^GCOMPACT
(at least according to docs http://docs.intersystems.com/documentation/cache/cache5docs/PDFS/GMSM.p…)
Based on the results of %GSIZE you now compact those globals with most blocks and lowest packing.
This generates free blocks that will be eliminated during GBLOCKCOPY.
Routine ^%FREECNT might help you to follow up your efforts
Purpose: Displays the total amount of disk space within a volume group and the amount of free space.
HTH
- Log in to post comments
Documentation is the art to express facts in a way the non insiders could understand.
Engineers are quite often "unverbose" and "limited in verbal communication skills".
In any language exept programing languages
BTW. your book made things clear to me that I assumed to know for many years.
BTW. I appreciate if you accept my answer 
- Log in to post comments
Alexey,
- The final size after some design optimizations was
175 GB DataGlobals + 216 GB IndexGlobals ; separated for backup considerations (on 1 single drive )
- data analysis was all done with SQL + a bunch of "homemade" SQL Procedures / ClassMethods running specific subqueries.
- Log in to post comments
Amir,
I don't agree with you on %List
http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?…
There's no annotation to be reserved or not to use it
- Log in to post comments
You are welcome.
When I loaded the class first I was surprised too just to see 4 methods.
- Log in to post comments
To mark your question as "answered" on Developer Community, please click the checkmark alongside the answer you (as author of the question) accept.
- Log in to post comments
To mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept.
- Log in to post comments
HI Dave,
Great to meet you again on one of my favorite subjects.
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments
Pls. don't forget to mark your question as "answered" on Developer Community,
please click the checkmark alongside the answer you (as author of the question) accept
- Log in to post comments