Performance and Memory Usage with the Event Model of HSSF

[Ian Jackson]

I am using the HSSFEventFactory to read an Excel file that contains a 
mailing list. Most of the strings are unique. The rows are divided into 
14 cells.

I am print the time in seconds. My results are as follows:
Records                             Time in Seconds
500                                                            2
700                                                            3
800                                                            5
900                                                           56
1000                                                         247
I have observed that most of the time is spent prior to calling my 
abortableProcessRecord method in the class that implements 
AbortableHSSFListener to process LabelSSTRecord or NumberRecord.sid. 
Most of the time (55 second for 900 records) is spent between the call 
to processEvents and the handling of the  SSTRecord.

Has anyone come up for a solution to increase the preformance when a 
large part of the data is unique strings?

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]