GeeCON Prague 2014*
The moose likes JDBC and the fly likes performancr tunning in traversing through a resulset (to form a table model) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "performancr tunning in traversing through a resulset (to form a table model)" Watch "performancr tunning in traversing through a resulset (to form a table model)" New topic
Author

performancr tunning in traversing through a resulset (to form a table model)

deepak sisodia
Greenhorn

Joined: Oct 22, 2010
Posts: 3
Hi All,

I am new to swing and debugging an existing code for a performance tunning perspective. I have a resulset to display in a TableModel. Each row is having size of the resulset and to get that i used - Resulset tableRows = rs.getInt(1);Below is the code of my DatabaseTableModel class.



This tablemodel is a time consuing. Please help me to tune this to a minimum extent.

Thanks
Deepak
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19697
    
  20

Welcome to the Ranch, Deepak!

Your GUI stuff seems to be alright; there is little you can do about that, except perhaps use a SwingWorker to do all this work in the background. Since the tuning needs to be done on the ResultSet I'll move this thread to our JDBC forum.

Oh, and please UseCodeTags next time. I've added them for you this time.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
GeeCON Prague 2014
 
subject: performancr tunning in traversing through a resulset (to form a table model)