The moose likes JDBC and the fly likes peformance problem in application Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » JDBC
Reply Bookmark "peformance problem in application" Watch "peformance problem in application" New topic
Author

peformance problem in application

Kristof Camelbeke
Ranch Hand

Joined: Nov 28, 2001
Posts: 97
Hello,
I have this problem that I first thought had to do with a memory leakage but I think it is something else.
This is the situation in the application :
When the user selects an item, a query is made on a database selecting items and putting them in a Jtable (I work with an AbstractTableModel).
This works fine except after a while everything slows down to the point that you can't select anything anymore.
Now my question :
Does this problem occur because I am doing a query everytime an item is selected ?
Is this a correct way to deal with a ListSelectionEvent ?
Is it maybe better to read the whole table in an ArrayList at the start of the program and work with this ArrayList during runtime ?
I really don't know what's going on so any help is appreciated.
Thanks,
Kristof
 
IntelliJ Java IDE
 
subject: peformance problem in application
 
Threads others viewed
can radio set handle one item?
control flow problem
Empty ArrayList
Validation of indexed properties
How to handle a list in JSF 2
IntelliJ Java IDE