Fix memory usage on export #28
Loading…
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Ref https://github.com/yulqen/datamaps/issues/11
Use of a blank template in region of 3/4Mb leads to a RAM max-out at around 18 templates and subsequent machine lock.
Test files are in
dft/bcompiler_engine_issue_28.zip.Thanks Matt.
Do you know which part of the template requires some much memory? I think in the past you have used a method for looking into workbooks to see which worksheets hold a lot of memory. If you can explain/show me how you do that, that would be very useful.
"sheet16.xml" (which I think is 5A...) is 76Mb uncompressed for some reason. There were millions of empty rows in the XML file - to the point where I couldn't jump to the bottom of the file in my editor. However I was able to delete them and resave and I've just run the export and it ran the lot in about 3 minutes. I don't know what's caused this. I'll send everything over to you, including the fixed
blank_template.xlsm. Be warned - that file may now be even more unstable due to me rippings it's internals out, but it seems to have worked for now.Thanks Matt. Files corrupting is an occupational hazard when working with excel.