• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

performance issue

 
khaled hanafy
Greenhorn
Posts: 25
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hi Guys ,

i made an applicatiom that read from txt file "which contain approximatly 4500 rows" and made processing on each row and then print the results in Excell using POI API , but it's very slow it takes 30 minutes !!

is there any recommendation or design pattern should i know to increase the application's performance ?
 
John Jai
Rancher
Posts: 1776
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you doing reading of the text files and then writing into Excel concurrently?

Then, try read the text file line by line - process it and store the data in a custom helper class object.

Finally after processing write the helper object information into the excel sheet.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic