wood burning stoves 2.0*
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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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: 16019
    
  20

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