File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes I/O and Streams and the fly likes performance issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » I/O and Streams
Bookmark "performance issue" Watch "performance issue" New topic

performance issue

khaled hanafy

Joined: Jun 28, 2010
Posts: 25

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

Joined: May 31, 2011
Posts: 1776
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.
Don't get me started about those stupid light bulbs.
subject: performance issue
Similar Threads
native vs byte code
Performance Monitoring in WebSphere using Tivoli Performance Viewer
2 dates per post?
Java3D: Which is better: OpenGL or Direct3D?