A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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.
Ping & DNS, my free Android app for network diagnostics
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!!
I agree. Here's the link:
subject: Writing Excel in java takes hours to create.
Transfer Excel Sheet information to database
Outputting sql output to spreadsheet
Upload the Excel data in the Oracle Database
is "Microsoft Office Specialist Certification: Microsoft Office Excel 2010 (Expert)" worth it?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014