https://bz.apache.org/bugzilla/show_bug.cgi?id=65042

            Bug ID: 65042
           Summary: Writing pircture to workbook cause memory leak due to
                    picture data is to much in memory.
           Product: POI
           Version: 4.1.2-FINAL
          Hardware: Macintosh
                OS: Mac OS X 10.4
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: SXSSF
          Assignee: [email protected]
          Reporter: [email protected]
  Target Milestone: ---

Created attachment 37670
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37670&action=edit
Memory Usage Dump

Sxssf using Xssf handle its picture. So picture will save in memory, not flush
with row. This means if we have a lot of pictures had to write in xlsx, this
will cause memory leak which was I am struggling with. I can't find a way to
flush picture data before workbook.write().

The test case is, 300kb picture, one row write 10 pictures. JVM -Xmx128m.
There will be an oom when write 50 rows. In that time, the picture data list
will have 60mb in memory.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to