I have this document which has less than 4000 rows but is almost reaching 9mb out of a total of 10mb. I suppose I can improve it. But I don´t know how to audit the document to check where and how I can improve data usage.
Unfortunately, we don’t have a tool yet that’s like Formula Timer but for summarizing storage requirements by column. You could try something manual by downloading the full SQLite file, or exporting particular tables to CSV.
The one thing I’ve seen to cause unexpected huge sizes is the Notepad custom widget. If you use that at all, that’s what I would suspect. The issue is that it stores the entire Notepad doc inside the cell, which includes images (it encodes them as text inside a cell). So a bunch of images in Notepad can blow up the size of the document.
I gave the code to chat GPT to analyze.
I have some big formulas but most of them are located in tables with few records.
However there is a formula with over 100 lines that is located in a table with 792 records.
ChatGPT calculated that alone is occupying about 2.3 Mb.