--- In firebird-support@yahoogroups.com, 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..