-Xmx16G -Xms8G -Xss256k are your friends. Cheers.
On Thu, 2015-07-02 at 02:00 -0700, karthikeyan S wrote: > i tried that Iterating but it only reading 5.5Lks rows only then it produce > > Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit > exceeded > at java.util.Arrays.copyOfRange(Unknown Source) > at java.lang.String.<init>(Unknown Source) > at java.lang.StringBuffer.toString(Unknown Source) > at > org.apache.poi.xssf.usermodel.XSSFRichTextString.utfDecode(XSSFRichTextString.java:489) > at > org.apache.poi.xssf.usermodel.XSSFRichTextString.getString(XSSFRichTextString.java:294) > at > org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.java:247) > at utils.newexcelreader.readData(newexcelreader.java:82) > at utils.newexcelreader.main(newexcelreader.java:39) > > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/How-to-read-1-million-rows-in-excel-xlsx-format-using-Apache-poi-tp5719275p5719278.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] >
signature.asc
Description: This is a digitally signed message part
