Dear ODF Toolkit Developers,
I have obtained a performance issue in ODF Toolkit mostly related with APPEND SHEET method. ODF Toolkit is very slow when appending many (40+) Sheets into one Workbook … Especially if those sheets are big - like tables 5,000 x 20 . … Appending 40 spreadsheets with 5000 x20 takes ~ 30 min, Please see link: <https://issues.apache.org/jira/browse/ODFTOOLKIT-422> https://issues.apache.org/jira/browse/ODFTOOLKIT-422 . Before describing technical details may I ask you : - Is it something other developers / users are experiencing too ? or - We are doing something wrong ? Do you know if someone ( or maybe you ) did such kind of tests ? - opening and appending big spreadsheets? Like 5000 rows and 20 columns . See also Nick’s comment on Jira https://issues.apache.org/jira/browse/ODFTOOLKIT-385 and https://issues.apache.org/jira/browse/ODFTOOLKIT-422. He did Load, Write data and sheet append performance test; See repo here: https://github.com/ngochiashvili/odftoolkit-performance-test Any help, recommendation and/or feedback highly appreciated. Thanks Kakha&Team
