3 ms·
My CSV story from last night: I had these 15MB+ excel sheets and was trying to open them with Apache POI. I gave that code a generous 2GB memory: GC overhead l
by beders 6y ago
My CSV story from last night:
I had these 15MB+ excel sheets and was trying to open them with Apache POI. I gave that code a generous 2GB memory: GC overhead limit reached.
Then I opened them in Excel, saved them as CSV, reached for a CSV-library and was done within seconds.
Ok, well, the story is more about how parsing XML can ruin your day ;)
- mike22 6y agoAre you using POI’s eventmodel APIs to handle such files? The SAX model isn’t too bad for reading files.