[news.eclipse.platform.swt] Re: Huge table, records, scrolling, etc.

[Haris Peco <snpe@xxxxxxxxxx>]

i use JTable (JXTable from swingx) for this and Swing/AWT features
and implement list table model - list read data from database with 
scrollable resultset 

Mr. Burns wrote:

> Hello Joe,
> 
> thanks for reply, you say the rest is trivial, but if one is new to SWT
> its not like database programming under C++ as I did do usually.
> What you mean if you say: 'records should not change sequence and
> information during browsing'?
> And whaot you mean if you say 'unless change using editors'?
> 
> My main problem is what I should program within the SWT.SetData listener
> to deal with the database?
> To fill the table with the text "item " + index, as Grant show in the
> snippet is trivial.
> But to deal with database causes more problem. Should I place code there
> to read only one record out of the database?
> (like one record created by "Item " + Index)
> But then if I scroll down, lets say for 25 records, the listener is
> executed 25 times reading only one record.
> So the database receives 25 SQL Select ... statements.
> Because of efficiency I would go a different way just sending only one
> SELECT ... statment receiving 25 records within one resultset. This will
> reduce database traffic. But of course than the code inside the listener
> is more difficult, because it is executed once for every new record which
> is to read, but only every 25th execution a new SELECT statement to the
> database will be necessary.
> 
> Do you understand what I mean?
> 
> Thanks for any comments which way to go,
> 
> best regards,
> 
> Mr. Burns