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

["Joe Smith" <ohcho@xxxxxxxxxx>]

"Mr. Burns" <Mr._Burns@xxxxxx> wrote in message 
news:dj00bi$2a8$1@xxxxxxxxxxxxxxxxxxx
> Thanks for reply,
>
> but this does not really answer my question, I wanted to know how I fetch 
> now the records from DB and where to store.
> I want now each time the SWT.SetData trigger is executed, check if next 25 
> records are to preload. If yes what is the best way to store/cache these 
> records? Should I use a vector? Should I use a 2nd table where I cache the 
> records in the TableIems and copy them into the virtual table?

How big are your tables?
If you have to cache all inside your program, it's better not to
use virtual table. In addition, can you access your tables
using indexes, say, 0, 1, 2, ..n? If you don't have keys,
then create temporary result tables inside dbms and
fetch partially. You may need to have some local cacheing
systems. Otherwise, for each row, there will be connection,
query and fetch statements executed resulting in slow speed.
So you need to develop some local caching capability
along with temporary tables.


>
> Thanks for further discussions!
>
>