--- In [email protected], Mark Rotteveel <mark@...> wrote: > > On Fri, 31 Aug 2012 08:23:17 -0000, "williamevanw" > <williamevanw@...> > wrote: > > 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.. > > You should query what you need using the ROWS clause in your select > statement. > http://www.firebirdsql.org/refdocs/langrefupd25-select.html#langrefupd25-select-rows > > It has been a while since I used JTable, but I seem to recall that you > should be able to define events when it needs more rows and then query > those rows to update your TableModel. One thing you should take into > account however is that it is unwise (performance wise) to try to query the > total amount of rows beforehand (eg using SELECT COUNT(*)), as that is an > inefficient operation in Firebird. > > Ideally you would want to use scrollable ResultSets for this, but that > will actually result in Jaybird loading all rows anyway. > > Mark >
Hi Mark, Thanks for your assistance. I have never used the "rows" component in SQL before, but I am sure that I will be able to achieve what I wanted now..
