On ocasion almost always by mistake, I have the limit
rows unchecked and run a query that returns 10,000
rows. This will always freeze SQuirreL till the out of
memory error and at that point I can sometimes
continue with SQuirreL and sometimes have to kill it
How about a "paging feature" that would render say 1000
rows wait for the user to press a next button and
return the next 1000 rows. Using scrollable RS will
allow forwards and backwards paging.
The JDBC scrollable RS can also be used for the
updating from the JTable feature that is planned for
1.2 (should it be 2.0?)
) I have not used this yet but would it make sense to
use in SQuirreL?
Sun has an early access CachedRowSet
It is my understanding that the CachedRowSet will also
increase performance due the fact that it is
disconnected from the DB. There are licensing issues
with Suns implementation of the CachedRowSet
("Developers cannot redistribute the binary software in
commercial products. Please see license for terms and
conditions. " form the above link)
Is this too cutting edge?
Log in to post a comment.