By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,234 Members | 1,869 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,234 IT Pros & Developers. It's quick & easy.

Performance on form with a quite big dataset

P: n/a
How do I speed up the loading of a form with a dataset of 20000 records?
regards
reidarT
Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


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

"ReidarT" <re****@eivon.no> wrote in message
news:eQ**************@TK2MSFTNGP14.phx.gbl...
How do I speed up the loading of a form with a dataset of 20000 records?
regards
reidarT

Nov 21 '05 #2

P: n/a
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
Nov 21 '05 #3

P: n/a
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" <no************@planet.nl> skrev i melding
news:ei**************@TK2MSFTNGP12.phx.gbl...
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

Nov 21 '05 #4

P: n/a
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
Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.