Re: Fast Load?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jon Skeet [C# MVP] (skeet_at_pobox.com)
Date: 08/13/04 

Date: Fri, 13 Aug 2004 09:00:02 +0100

John <jo@jonkar.ca> wrote:
> I posted this in the pocketpc.developer newsgroup but maybe this is the
> place to ask....
>
> I have created a VB.NET CE Pocket Pc 2002 application, and I need to load a
> combobox really fast from the SQL CE database...
>
> I have tried the DataAdapter.Fill(Dataset), and also the DataReader While
> Wend.
> They seem to take about the same amount of time to load (a few seconds)
>
> I have Three Tables, Books, Codes, and Book_Codes
>
> Codes is loaded into a Combobox and when the user selects a Code;
> Books Combobox is Loaded: Select * From Books, Book_Codes Where
> Book_Codes.BookID = Books.BookID
>
>
> Any one have a faster way of loading the combobox...

Well for a start, I wouldn't use SELECT *. Only load the columns you
absolutely need - and I'd recommend specifying which columns those are.
That way if extra columns are added later and you don't need them, you
won't get a performance penalty. 

-- 
Jon Skeet - <skeet@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

Relevant Pages

  • Re: Fast Load?
    ... > They seem to take about the same amount of time to load ... > Codes is loaded into a Combobox and when the user selects a Code; ... > Any one have a faster way of loading the combobox... ...
    (microsoft.public.sqlserver.ce)
  • Getting data from file into comboboxes and listboxes
    ... I scanned the newsgroup and found ... The names and addresses of the people are in a word merge data file which I ... load a combobox with the names, then when this is selected add the ...
    (microsoft.public.word.vba.userforms)
  • Fast Load?
    ... They seem to take about the same amount of time to load ... I have Three Tables, Books, Codes, and Book_Codes ... Codes is loaded into a Combobox and when the user selects a Code; ...
    (microsoft.public.sqlserver.ce)
  • SQL CE need a faster load...
    ... They seem to take about the same amount of time to load ... I have Three Tables, Books, Codes, and Book_Codes ... Codes is loaded into a Combobox and when the user selects a Code; ...
    (microsoft.public.pocketpc.developer)
  • Re: 100K item data binding: Is asynchronous data binding possible?
    ... After attempting to load the data on another thread it seems that - as we ... predicted - the "choke" still occurs ON the databind. ... private void callbackGetAccountsOnAnotherThread ... You aren't going to be able to bind to the ComboBox asynchronously. ...
    (microsoft.public.dotnet.languages.csharp)