Thanks Karl, for the inputs. Will have a look at the event model to see if its feasible in our project. regards, -Jaikiran
"KHZ (SAW)" <[EMAIL PROTECTED]> wrote: Hi Jaikiran. Improving speed is possible by using the event model instead of the user model. But then you do the things by foot. Regards, Karl-Heinz. -----Ursprüngliche Nachricht----- Von: jaikiran pai [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 11. August 2006 11:25 An: [email protected] Betreff: Performance of POI-HSSF Hi, We just started using POI-HSSF - Java API To Access Microsoft Excel Format Files. We have xls files which contain huge amounts of data. While testing out the APIs provided by POI-HSSF, we observed that the time taken to create a HSSFWorkbook out of a stream, it takes around 6 seconds(the workbook had 1 sheet and 20000 records). Here's the code that we used to load the xls: long start = System.currentTimeMillis(); POIFSFileSystem fs1 = new POIFSFileSystem(new FileInputStream("C:\\temp\\New_20000.xls")); HSSFWorkbook locationsWorkbook1 = new HSSFWorkbook(fs1); //takes 6 seconds. long end = System.currentTimeMillis(); System.out.println("Time taken to load xls: " + (end-start)); Is there any performance metric available for POI-HSSF. Is there any way that this performance can be improved. Our xls file contents start from 20000 records and might even run into 200000 records. Thank you. regards, -Jaikiran --------------------------------- Heres a new way to find what you're looking for - Yahoo! Answers --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------- Heres a new way to find what you're looking for - Yahoo! Answers
