This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
The moose likes JDBC and the fly likes Performance Problems with DB Connection Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of Arduino in Action this week in the General Computing forum!

A special promo: Enter your blog post or vote on a blogger to be featured in an upcoming Journal
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Performance Problems with DB Connection" Watch "Performance Problems with DB Connection" New topic
Author

Performance Problems with DB Connection

Rachel Thornton
Greenhorn

Joined: Aug 04, 2003
Posts: 5
posted
0
Quote
I am creating a single-user application that requires database connection. I'm using a MS Access database, and have the connection set up fine. I am setting up a connection when the app is started and keeping it open until the app is closed, but I'm getting performance issues (mainly my Swing components aren't being shown properly). Are the performance issues to do with the constant connection to the database ? Would it be better to keep opening and closing the connection ?
Thanks
Rachel
Jon Strayer
Ranch Hand

Joined: Dec 04, 2002
Posts: 133
posted private message
0
Quote
I doubt it, but you didn't really give us enough information to tell for sure.
Try running a profiler to see why the code is slow.

Jon
Rachel Thornton
Greenhorn

Joined: Aug 04, 2003
Posts: 5
posted
0
Quote
I've foudn the problem. Nothing to do with the database. It's a problem with my Swing.
Thanks anyway!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Performance Problems with DB Connection
 
Similar Threads
Hot Deploy DataSource in Tomcat?
Commons DBUtils -Known issues and performance
Business logic in PL/SQL?
WebSphere 4.0.1 AE load balancing
Two TransactionTemplate use my single application.