• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Performance Problems with DB Connection

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 133
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Rachel Thornton
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I've foudn the problem. Nothing to do with the database. It's a problem with my Swing.
Thanks anyway!
reply
    Bookmark Topic Watch Topic
  • New Topic