Sorry for opening a can of worms here.
I was intending to post my code so I thought I'd refactor it a bit to make the intent clearer. I don't really know what I did but a run now takes about about the same time as outputting csv. On my
machine it went from over 4 minutes to just over 2 minutes.
1000 per second isn't bad provided there are a few cells in there (which
you have). that 42000 cells per second, which
is pretty good actually considering. Thats 0.23809524 seconds per
cell I'm happy with that :-)
The "stupid thing" that you're doing is that your pauses could be longe
Avik Sengupta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 16:55
To: [EMAIL PROTECTED]
Cc: poi-user@jakarta.apache.org
Subject: Re: Time to add/update cells
On a 1.8GHz linux (2.6) with jdk1.4.2, I can insert rows at approx 1000
per second. Except for brief pauses due to garbage collec
]
Cc: poi-user@jakarta.apache.org
Subject: Re: Time to add/update cells
On a 1.8GHz linux (2.6) with jdk1.4.2, I can insert rows at approx 1000
per second. Except for brief pauses due to garbage collection, the rate
is resonably consistent. I've tried inserting 5000 rows with 42 cols
each.
Attached is a
On a 1.8GHz linux (2.6) with jdk1.4.2, I can insert rows at approx 1000
per second. Except for brief pauses due to garbage collection, the rate
is resonably consistent. I've tried inserting 5000 rows with 42 cols
each.
Attached is a graph showing this performance, the behaviour should be
pretty o
[EMAIL PROTECTED] wrote:
Another question about this...
On neither machine does memory use approach the max allocated.
Are you speaking about the total memory, or about the JVM assigned
memory?
I mean, do you check the memory by using
Runtime.getRuntime().totalMemory() and
Runtime.getRuntim
Another question about this...
>> On neither machine does memory use approach the max allocated.
Are you speaking about the total memory, or about the JVM assigned
memory?
I mean, do you check the memory by using
Runtime.getRuntime().totalMemory() and
Runtime.getRuntime().freeMemory()...
__
Thats some odd time. I achieve much better on my box. First off set
your MINIMUM heap size so that it doesn't grow and shrink. Second off,
make sure the heap is at least 50-60% larger than the high water mark of
usage (due to generational garbage collection. Last off, use the 2.6
kernel. L
Hello,
I have recently tried to use POI to add a few thousand rows to a
spreadsheet.
It doesn't make much difference if I start with an almost blank
spreadsheet or one with dummy values in the all the cells that will be
populated on a run of known size.
I have 42 columns.
Operations move fai