[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
- References:
- [news.eclipse.platform.swt] Huge table, records, scrolling, etc.
- [news.eclipse.platform.swt] Re: Huge table, records, scrolling, etc.
- [news.eclipse.platform.swt] Re: Huge table, records, scrolling, etc.
- [news.eclipse.platform.swt] Re: Huge table, records, scrolling, etc.