VB.NET CF Caching question...

  • Thread starter Thread starter dwhittenburg
  • Start date Start date
D

dwhittenburg

This may not be available, but I thought I'd ask...

On load of the application I am loading several TreeViews, so that the user
won't have the burden of these loading once they use them...One of the
TreeViews is loading 2600 rows from the sqlce database...This is taking
around 14 seconds to load (probably expected)...The 2600 rows will not
change unless the user requests for this data to be updated and thus
anything referencing this data (objects etc) would have to be updated...

1...I could only load the header and load the rest of the data on demand,
but that would add time on the user's end once they got to that point...

2...Does the Compact Framework support Serializable Objects?

3...Is there another way?

Thanks for the help...
 
Off the top of my head my vote goes with 1. Load on demand hence spreading
the processing time is almost always the best answer on devices...

Cheers
Daniel
 
First I have to agree with Daniel, why would you load 2600 rows if the user
is only inetersted in one?
Loading all rows at startup is not really a client/server aproach.

Assuming that all forms are bound to the same dataset, each form can
subscribe to datatable notifications which will be fired whenever a
row/column in the table has been changed e.g.
AddHandler mDataTable.RowChanged, AddressOf RowChanged

AddHandler mDataTable.ColumnChanged, AddressOf ColumnChanged

Regards,
Tom
 
Thanks, I went with this option...it seems to work well...
It's just that they are going to have to experience the latentcy at least
once every time they run the program from new again...
 
Back
Top