Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Performance of Swing application

 
Paras Ahuja
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 18304
56
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Paras Ahuja
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic