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 Murach's Java Servlets and JSP this week in the Servlets 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: 15950

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
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
What is the best way to store List<List<String>> in database?
generate large XLS file using java