| 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: 14480
|
|
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.
|
 |
 |
|
|
subject: Performance of Swing application
|
|
|