|Summary:||CommentsTable.getCTComment() has poor performance|
|Component:||XSSF||Assignee:||POI Developers List <dev>|
Description Alex 2010-06-13 08:32:02 UTC
CommentsTable.getCTComment() always goes over all comments. Run time is O(n^2). In large Excel file when checking if cell has warning a total time that spent in this method can take many minutes. By keeping the table in Map<String, CTComment> where key is comment.getRef() the run time imporved dramatically. Also in XSSFSheet.read() method inside condition "if(p instanceof CommentsTable)" there is no "break" which should stop unnecessary processing.