[jira] [Resolved] (METAMODEL-187) ExcelDataContext uses more memory than it needs to for File-based resources.

["Kasper Sørensen (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/METAMODEL-187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kasper Sørensen resolved METAMODEL-187.
---------------------------------------
       Resolution: Fixed
         Assignee: Kasper Sørensen
    Fix Version/s: 4.4.0

> ExcelDataContext uses more memory than it needs to for File-based resources.
> ----------------------------------------------------------------------------
>
>                 Key: METAMODEL-187
>                 URL: https://issues.apache.org/jira/browse/METAMODEL-187
>             Project: Apache MetaModel
>          Issue Type: Bug
>            Reporter: Dennis Du Krøger
>            Assignee: Kasper Sørensen
>            Priority: Minor
>             Fix For: 4.4.0
>
>         Attachments: Memory use File-based.png, Memory use InputStream-based.png
>
>
> ExcelDataContext uses the input stream from resources, even if it is a FileResource. This is pretty wasteful memory-wise, both according to http://poi.apache.org/spreadsheet/quick-guide.html#FileInputStream and to own tests; I made a naïve change that uses the internal File of FileResources on a huge file. With InputStream, getting the defaultSchema used around 950 MB in average, while it used around 650 in average with the File based version (nothing scientific, just eyeballed in JVisualVM).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)