File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Java » Swing / AWT / SWT
Bookmark "Performance of Swing application" Watch "Performance of Swing application" New topic

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: 17270

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.

An IDE is no substitute for an Intelligent Developer.
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:
subject: Performance of Swing application
It's not a secret anymore!