JDBC Resultset Cache
Posted on 2011-05-06
I have a swing app that displays a JTable whose underlying data comes from a JDBC resultset. The app runs fast on the local network, but if we use it across the internet (at 60KBytes/Sec speed max), it is slow, even to scroll left to right.
What ways can I speed up the app?
It is understandable that scrolling up/down the table can be a little slow if necessary, but left and right should be fast. I figure I should put a jdbc resultset cache, and have seen discussions about CachedRowSet. I'm not sure what I have to download to make that work. And if there are other ways to cache.
I'm open to other ideas and solutions, so long as I don't have to rewrite the entire app and turn it upside down!