longlong String cause hard disk boom

[ameue]

A field holds 84000 + length JSON strings, and hard disk usage has soared by 27M。
The same data is stored in SQLite and realm, realm takes up much more space than SQLite

[bmunkholm]

In general, Realms are not larger than SQLite.

1. What's the total size of the strings you are storing?
2. How much space is it taking up in SQLite?
3. How do you add the data?
4. Are you aware that Realms will expand in larger increments to also cover potential future additions (to make it faster instead of expanding a file in small increments). If you don't need that you can compress the file at startup or by opening it in Studio and saving it again. Please try that and report the file size.

[ameue]

I convert the data into a JSON string and save the JSON string in a field.
After that, I saved the JSON string to sandbox first, and then saved the file path in realm. But in this way, the space occupied was reduced to several hundred KB, but it was still larger than sqlite.

[bmunkholm]

@ameue Please answer my original questions 1-4 so I can better understand the issue and help you.

In your second experiment:
5. You now no longer save the strings in Realm, but only store a path to a file? And that is taking up several hundred KB? What exactly is stored in it? Please share a screendump from Realm Studio or the file itself.
Note that a realm will have a minimum size and grow in larger chunks. If you delete data from the realm it does not shrink the file unless you compact it.
6. Is it a problem for you that it is several hundred KB?
7. In comparison what is the size in sqlite? You only write that it is larger - please be specific.

Please provide a small sample project that demonstrates how you generate the string for the initial case so we can reproduce it and see the difference between the data you store in realm and the size of the file it generates.

[stennie]

Closing this issue due to no recent activity. Please comment if you have additional information that may help reproduce this issue.