[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [Newsgroup Home]
[news.eclipse.platform.swt] Re: Huge table, records, scrolling, etc.

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