Analyze object sizes #415
-
|
We have recently been asked why our database is "so huge". So I have been wondering how I can find that out. Since there aren't separate files per entity, like there are tables in SQL per entity, I can't really tell. Is there some kind of API or way to do this? Couldn't find anything in the docs unless I missed it. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 13 replies
-
|
A "dumb" way to find out is to create an empty storage and then create like 100 entities of the same object and check how much bigger the storage file is and then calculate each entities individual size in bytes. We did this for the objects which we expected to be large to get an estimation of how big they are without having to calculate object size directly. |
Beta Was this translation helpful? Give feedback.
-
|
Filesize As far as I know zombies like that SHOULD regularly be cleaned up, no? Otherwise i'd have a massive missunderstanding i guess :D |
Beta Was this translation helpful? Give feedback.
-
|
Should...I am not sure if it happens or not tbh 😂 |
Beta Was this translation helpful? Give feedback.
-
|
Yeah ... honestly I couldn't care less about the filesize, but we have a shitty legacy VPN and Windows Samba share, both are slow. So people are bothered by having to move around database from their different testversions and stuff. This SHOULD not be a problem ... but it is. People just love using subpar tech, what can I say :D |
Beta Was this translation helpful? Give feedback.
-
|
There is the option to get some information on the storage files: |
Beta Was this translation helpful? Give feedback.
-
That sounds great, thanks! I will try that. |
Beta Was this translation helpful? Give feedback.
-
There we have it. Thank you very much I will try this out myself aswell :) |
Beta Was this translation helpful? Give feedback.
-
|
Hey @hg-ms , so this is already quite helpful, but I am a bit confused. I get 50% live data, shouldn't that mean that |
Beta Was this translation helpful? Give feedback.
-
|
There are some options to configure the housekeeping in case the default settings are not sufficient. |
Beta Was this translation helpful? Give feedback.
There is the option to get some information on the storage files:
org.eclipse.store.storage.types.StorageConnection.createStorageStatistics()it provides the ratio of obsolete and actual data for each storage file.