[jira] [Commented] (ODFTOOLKIT-463) Performance issues

["Martin Maråk (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ODFTOOLKIT-463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16431849#comment-16431849 ] 

Martin Maråk commented on ODFTOOLKIT-463:
-----------------------------------------

I am having the same issue, writing a spreadsheet with 50 columns and 5000 lines takes over 10 minutes, while the equivalent csv file is done in less than 5 seconds. It seems that getCellByPosition(column,row) is the culprit.

> Performance issues
> ------------------
>
>                 Key: ODFTOOLKIT-463
>                 URL: https://issues.apache.org/jira/browse/ODFTOOLKIT-463
>             Project: ODF Toolkit
>          Issue Type: Bug
>            Reporter: Thomas Hackel
>            Priority: Minor
>         Attachments: odf-hotspots.png
>
>
> Version: 0.8.2-incubating  (not present in JIRA)
> I have different "output writers" for formats like ODF/CSV/POI etc.
> The ODF version is the slowest of all, it might be a usage problem or a ODFToolkit issue.
> It seems that creating new Rows/Cells is consuming a lot of time.
> All other implementations have the QueryDSL.fetch method as the major hotspot. With ODFToolkit this data gathering method is only at place 3.
> All what i am doing is creating a new row for each line of data:
> {code:java}
> row = table.getRowByIndex(rowNumber);
> {code}
> I am talking about only 6000 rows.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)