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
0
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
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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
