incubator-odf-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rafael Medeiros <mederaf...@gmail.com>
Subject Re: ODF Performance
Date Fri, 31 Jan 2014 13:31:47 GMT
Suggestions to improve peformance:

1 - Create cells without informing the style increases the file size,
always tell the name of the style - decreases the file size;
2 - When was merge, remove the contents of the cell and then do the merge;

Atenciosamente,

Rafael Nunes
I'm free - Linux
Linux User #439174
http://www.linkedin.com/in/mederafael


On Fri, Jan 31, 2014 at 9:25 AM, Nicholas Evans <nick.evans@inology.nl>wrote:

> Dear ODF users,
>
> For a project I am working on, I am using the ODF toolkit to create
> spreadsheets that can become rather large (>10 000 rows).  I have noticed
> that as the spreadsheet gets larger, writing the rows becomes very slow.  I
> have put together a class containing 4 different ways of writing 10 000
> rows of 10 columns to a spreadsheet.  The fastest method (using
> getRowByIndex and then getCellByIndex) takes 70 seconds.  The methods that
> use getRowList and getNextRow are much slower, taking about 170 seconds
> each.  The method using the Iterator<Row> seems to freeze for large inputs,
> and doesn't behave as expected for small inputs.
>
> I would really like to improve this performance.  I think this could be
> done by manipulating the DOM directly.  However, it would great if there
> was a way of using the Simple API that I have overlooked that could help me.
>
> Does anyone have experience with improving the performance of the ODF
> toolkit in the context of writing rows to an ods spreadsheet?
>
> Regards,
> Nick
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message