Subject Return SQL result in portions / progressively load result set
Author williamevanw
Hi guys,

I have several database tables that can grow to contain more than a million records. These tables are loaded into a jTable and then displayed to a user and sometimes take quite some time to load.

Is there a way to progressively load the resultset into the jtable? Do it in sections so that the user sees the records are being loaded instead of waiting?

I would imagine that this can be accomplished either by SQL or by an unknown feature or setting in the database..

I don't know where to start looking..

Any advice or guidance greatly appreciated..