tableau / community-tableau-server-insights

Community-built data sources for answering questions about Tableau Server
MIT License
129 stars 52 forks source link

Size is Sometimes Incorrect on TS Content #66

Closed PatrickGMI closed 1 year ago

PatrickGMI commented 2 years ago

I am using TS Content to analyze large disk footprints. I am using (Folder) Item\ (Measure) Size (MB). The number reported doesn't always appear to match reality. Sometimes the number reported by TS Content is much higher than the size of a data source when downloaded from the server to my local hard drive.

At first, I thought that it might be due to versioning: multiple historical copies of the item stored on the server. However, even after deleting all of history, or checking a newly published extract, the size was still not matching.

What is the size field measuring for TS Content Items? I can't seem to figure out how it correlates to actual file sizes. This is against v2.02 of TS Content, and v2021.1 of Tableau Server.

mcoles commented 2 years ago

Are you looking at the size of a .twbx / tdsx? Those are compressed. You could try extracting the .hyper file and comparing that size to what TS Content says.

On Thu, Mar 3, 2022 at 8:41 AM PatrickGMI @.***> wrote:

I am using TS Content to analyze large disk footprints. I am using (Folder) Item\ (Measure) Size (MB). The number reported doesn't always appear to match reality. Sometimes the number reported by TS Content is much higher than the size of a data source when downloaded from the server to my local hard drive.

At first, I thought that it might be due to versioning: multiple historical copies of the item stored on the server. However, even after deleting all of history, or checking a newly published extract, the size was still not matching.

What is the size field measuring for TS Content Items? I can't seem to figure out how it correlates to actual file sizes. This is against v2.02 of TS Content, and v2021.1 of Tableau Server.

— Reply to this email directly, view it on GitHub https://github.com/tableau/community-tableau-server-insights/issues/66, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADR4TT4QYQGIH2OO6GFOVY3U6DTUHANCNFSM5P3ADJNQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you are subscribed to this thread.Message ID: @.***>

PatrickGMI commented 2 years ago

Matt, Thank you. Yes, the size field is very close to matching when I compare the unzipped size. (One test showed ~0.3 MB higher on disk this time compared to the TS Content field. Still this is vastly closer than any other comparison we have tried.) Thanks! Patrick

From: Matt @.> Sent: Thursday, March 3, 2022 5:34 PM To: tableau/community-tableau-server-insights @.> Cc: Patrick Philipp @.>; Author @.> Subject: Re: [tableau/community-tableau-server-insights] Size is Sometimes Incorrect on TS Content (Issue #66)

EXTERNAL EMAIL: Are you looking at the size of a .twbx / tdsx? Those are compressed. You could try extracting the .hyper file and comparing that size to what TS Content says.

On Thu, Mar 3, 2022 at 8:41 AM PatrickGMI @.<mailto:@.>> wrote:

I am using TS Content to analyze large disk footprints. I am using (Folder) Item\ (Measure) Size (MB). The number reported doesn't always appear to match reality. Sometimes the number reported by TS Content is much higher than the size of a data source when downloaded from the server to my local hard drive.

At first, I thought that it might be due to versioning: multiple historical copies of the item stored on the server. However, even after deleting all of history, or checking a newly published extract, the size was still not matching.

What is the size field measuring for TS Content Items? I can't seem to figure out how it correlates to actual file sizes. This is against v2.02 of TS Content, and v2021.1 of Tableau Server.

- Reply to this email directly, view it on GitHub https://github.com/tableau/community-tableau-server-insights/issues/66, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADR4TT4QYQGIH2OO6GFOVY3U6DTUHANCNFSM5P3ADJNQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you are subscribed to this thread.Message ID: @.<mailto:@.>>

- Reply to this email directly, view it on GitHubhttps://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Ftableau%2Fcommunity-tableau-server-insights%2Fissues%2F66%23issuecomment-1058666831&data=04%7C01%7Cpatrick.philipp%40genmills.com%7Ca63fec9fd3cd4d7d82a308d9fd6e3a3f%7C0c33cce8883c4ba5b61534a6e2b8ff38%7C0%7C0%7C637819472768208385%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=Y%2B47Tz1F0tUCurVa3DbBX%2F5Cz7T7z%2B%2B4HdvuYsip6Uw%3D&reserved=0, or unsubscribehttps://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAJPF6GQXOHW3JLAW5OB2ESLU6FD4VANCNFSM5P3ADJNQ&data=04%7C01%7Cpatrick.philipp%40genmills.com%7Ca63fec9fd3cd4d7d82a308d9fd6e3a3f%7C0c33cce8883c4ba5b61534a6e2b8ff38%7C0%7C0%7C637819472768208385%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=W7LkovfYZ054J8g0nPkSPLPyFhk5nN4ZXS0%2BV0wcYe0%3D&reserved=0. Triage notifications on the go with GitHub Mobile for iOShttps://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapps.apple.com%2Fapp%2Fapple-store%2Fid1477376905%3Fct%3Dnotification-email%26mt%3D8%26pt%3D524675&data=04%7C01%7Cpatrick.philipp%40genmills.com%7Ca63fec9fd3cd4d7d82a308d9fd6e3a3f%7C0c33cce8883c4ba5b61534a6e2b8ff38%7C0%7C0%7C637819472768208385%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=Qj19V4HQCfKOJjUqkhCKhd61eLk10G%2BppmCi1hwGArw%3D&reserved=0 or Androidhttps://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fplay.google.com%2Fstore%2Fapps%2Fdetails%3Fid%3Dcom.github.android%26referrer%3Dutm_campaign%253Dnotification-email%2526utm_medium%253Demail%2526utm_source%253Dgithub&data=04%7C01%7Cpatrick.philipp%40genmills.com%7Ca63fec9fd3cd4d7d82a308d9fd6e3a3f%7C0c33cce8883c4ba5b61534a6e2b8ff38%7C0%7C0%7C637819472768364625%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=R94b0F5EBKR4tQgVCt6NajT8IcO%2FkQ6%2BvyF73gD%2FyCI%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.**@.>>


CAUTION: This email originates from outside of General Mills. Please consider carefully whether you should click on any link, open any attachment, or provide any information. For information regarding suspicious emails and what to do if you receive one, please visit http://go/security