[ODFTOOLKIT-422] PERFORMANCE ISSUE: 'format load', 'put data' & (!) "APPEND SHEET" (!)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.6.2-incubating
• Component/s: performance
• Labels: performance
• Environment: Windows & Linux
• Flags: Important
• Assignee: Svante Schubert
• Reporter: Kakha Kheladze
• Created: 16/Mar/16 15:15
• Updated: 15/Mar/17 13:04

Description

Dear Sir,

We are using ODFTOOLKIT for 3 main functions:
1. "Format Load" - Loading format into spreadsheet
2. "Put Data" - population table into spreadsheet , it could be table with 5,000 rows and 20 columns.
3. "Append Sheet" - Appending several sheets and assembling workbook. (up to 150 sheets)

We have a serious issue with performance, these 3 steps for 150 sheets with 5000x20 dimension may take more then 1h.

See some code below.

Any help or idea will be highly appreciated.

Kakha

---------------------------------------------------------------------------------------
@Override
public void setCellValue(int colIndex, int rowIndex, double value) {
try {
Cell cell = currentSheet.getCellByPosition(colIndex, rowIndex);
String valueType = cell.getValueType();
if (valueType != null) {
switch (valueType)

{ case "percentage": cell.setPercentageValue(value); break; default: cell.setDoubleValue(value); }

} else

{ cell.setDoubleValue(value); }

} catch (Throwable t)

{ log.error(t.getMessage(), t); }

}

---------------------------------------------------------------------------------------------------------

try (ByteArrayInputStream in = new ByteArrayInputStream(content))

{ spreadsheetDocument = SpreadsheetDocument.loadDocument(in); }

Issue Links

• depends upon: ODFTOOLKIT-427 PERFORMANCE: Table getRowCount, getRowByIndex cache improves getCellByPosition
• depends upon: ODFTOOLKIT-424 PERFORMANCE: Reuse XMLFactrories, currently created too frequently during insertNode and setTextContent.
• depends upon: ODFTOOLKIT-426 PERFORMANCE: simple Document.getCopyStyleList improvements to reduce String allocation, hashing, etc.
• relates to: ODFTOOLKIT-385 Table Performance