Performance on form with a quite big dataset

[ReidarT]

How do I speed up the loading of a form with a dataset of 20000 records?
regards
reidarT

 

[Marina]

The only way is to not load 20,000 rows. Does your application really truly
need all 20K in memory at once?

 

[Cor Ligthert]

Reidar,

On this are a lot of answers, however not by using code, it is all hardware
of database software.

The other way is ask yourself what Marina asked.

When it is not about printing with things as CS than your user will most
probably not able to see information in 20.000 records. It is than only data
on screen.

Cor

 

[ReidarT]

The main thing about accessing so many records is looking up persons date of
birth in a combobox and then select a person
and fill the fields like name, address and so on
regards
reidarT

 

[Cor Ligthert]

Reidar,

In my opinion is it than better to use a more selected approach, your user
will love you.

Give him first a combobox with years and than beside that with a month (the
calender is another approach however than he/she will probably not love you)
and than make a selection with a "where" clause depending from the text from
the combobox that he/she selected. To avoid typing errors you can use the
dropdownstyle. The month you can give in names while than the selectedindex
is your month. The year is in numbers so that is easy

And than use a button to start, so that when he does not select something
gets it all. (And than it is his/here choise to let it be a long time)

I hope this helps,

Cor