Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Refactoring for Software Design Smells: Managing Technical Debt
this week in the
OO, Patterns, UML and Refactoring
Java in General
Writing Excel in java takes hours to create.
Joined: Jan 24, 2005
Feb 21, 2013 03:30:44
I have a program that executes a sql and write the extract into
sheet, the resulset of sql fetched is about 400k and whole process is taking 3 to 4 hours.
Any suggestions how I can improve the time..?
Joined: Jan 28, 2003
Feb 21, 2013 05:06:57
The first thing is to figure out which step takes a long time so that you know whatever effort you put into optimizing gets applied to the correct place.
Joined: Mar 22, 2005
Feb 21, 2013 05:53:17
What does "400k" mean - 400000 rows? 400KB of data? Something else?
I agree with Steve that the first step is to figure what's taking up all that time - reading the data from the DB, or writing to an Excel file.
Joined: Feb 21, 2013
Feb 22, 2013 11:48:21
which API are you using? POI/Jxl or any other?
You just need to know where to find it!!
Have you checked out
subject: Writing Excel in java takes hours to create.
Outputting sql output to spreadsheet
is "Microsoft Office Specialist Certification: Microsoft Office Excel 2010 (Expert)" worth it?
Transfer Excel Sheet information to database
Upload the Excel data in the Oracle Database
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015