On 21-Mar-2014 11:09 -0700, rob@xxxxxxxxx wrote:
CRPence on 03/21/2014 12:31wrote:
On 20-Mar-2014 14:21 -0700, Sam_L wrote:
Directory /instancecache/relationships has 10,887 stream files.
Directory /instancecache/resources has 10,727 stream files.

They <ed: the directories> take about 85 mb each, and seem to be
all .XML files. <<SNIP>>

The naming clearly identifies the directories as /cache/, so
whatever feature presumably manages that data store is likely
similar to other cache implementations whereby they generally can
be ignored and assumed to be beneficial to the performance of the
feature; and at merely 85MB each, they would seem to be of little
concern regarding storage.

and at merely 85MB each,

I'm questioning his SQL statement. The whole directory size should
only be 85MB. Even with 11,000 files.

My understanding was that the "SQL statement" from the OP had yielded those same results; i.e. ~85MB/directory. Apparently what was implied in the OP, was not interpreted consistently.

The remainder of my reply deals only with clarifying my understanding, so is essentially off-topic:

I understood that the claimed SQL results from the OP had matched closely both with what Jeff posted and your expectations; i.e. matching closely both with what PRTDIRINF presumably would have shown for the size of the directories and what the the calculation (8k/file * 11000) yielded from WRKLNK information.

FWiW, I had inserted an <edit> to the text from the OP, that had clarified an assumption that I made; my interpretation of what the OP was implying. I understand that is easily overlooked, though is still visible in the above quoted text from the OP.

If curious why my interpretation differs, then read on.

The OP was written essentially as following three statements:

• &x contains &m files
• &y contains &n files
• "They" take &p storage each, "and seem to be all .XML files"

From that, I inferred the "They" refers to the aforementioned &x and &y. And given the subject of the sentence should not change suddenly due solely to comma as punctuation, the latter part of the sentence would imply the same subject "They", are ¿composed of? files. Thus, my interpretation of the third bullet is:

• "They" take &p storage each, and ["They"] seem to be [¿composed of?] all .XML files"

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact