This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Swing / AWT / SWT and the fly likes Performance of Swing application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Swing / AWT / SWT
Bookmark "Performance of Swing application" Watch "Performance of Swing application" New topic
Author

Performance of Swing application

Paras Ahuja
Ranch Hand

Joined: May 22, 2012
Posts: 62
I need to copy data from excel to ms access table. The excel sheet has around 7000 entries (that's only a part of what i am gonna add later) and it takes a lot of time to copy data (around 2-3 minutes).
Is there any way to improve the performance of the program. I am using JDBC-ODBC Bridge Driver to connect to excel and table and transfer data b/w them.
Thanks in advance
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 15959
    
  19

You could probably boost speed by using a native Excel reader such as Apache POI. The bridge driver is a last resort.

However you might also find it useful to get a copy of the Pentaho Data Interchange tool (also known as "Kettle"). It's a ready-made general-purpose Extract/Transform/Load application that can be "programmed" using a GUI designer app ("spoon"). It not only supports interchange to/from Excel and Access, but a lot of other things as well and it's tuned for automatic parallel processing. You can run it stand-alone or embedded into another app (Swing-based or not).

Disclaimer: I wrote some of the Excel support code for Kettle, so I'm not exactly unbiased.


Customer surveys are for companies who didn't pay proper attention to begin with.
Paras Ahuja
Ranch Hand

Joined: May 22, 2012
Posts: 62
Thanks Tim,
I have Apache POI. I would try to use that to improve performance. I would also look into your Pentaho Data Interchange Tool.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Performance of Swing application
 
Similar Threads
What is the best way to store List<List<String>> in database?
Read a .xls,.xlsx file format using XSSF
Excel size becomes large while creating excel file in jsp using content type
Copy excel file to access table
generate large XLS file using java