473,387 Members | 1,407 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Performance on form with a quite big dataset

How do I speed up the loading of a form with a dataset of 20000 records?
regards
reidarT
Nov 21 '05 #1
4 836
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Scott | last post by:
I have a customer that had developed an Access97 application to track their business information. The application grew significantly and they used the Upsizing Wizard to move the tables to SQL...
4
by: Martin | last post by:
I am using graphics as backgrounds for forms,buttons,labels etc. The question is: is it faster to load all graphics from files on app start or to use it embeded (places in editor during design)....
3
by: Glenn | last post by:
I have a performance issue that needs resolving, and am not sure which options we have come up with are the best. Let me explain. Our site has a report designer that allows users to create...
3
by: francois | last post by:
Hi guys, I have quite big troublesome performance problem. then i did a very simpkle page with a dropdownlist, when u click on it it makes a simple sql select on the SQL server and then...
7
by: Magnus | last post by:
Im using the new binding features of Visual Studio 2005. I have done the steps to create a bound data source, and selected all 40 tables from the database. The wizard generated the necessary code...
48
by: Alex Chudnovsky | last post by:
I have come across with what appears to be a significant performance bug in ..NET 2.0 ArrayList.Sort method when compared with Array.Sort on the same data. Same data on the same CPU gets sorted a...
2
by: Ryan | last post by:
My apologies if this is not the forum to post questions regarding .NET Remoting, but I figured WebServices would be the most appropriate forum of the bunch. We're currently completely re-arching...
4
by: skotapal | last post by:
Hello I manage a web based VB .net application. This application has 3 components: 1. Webapp (this calls the executibles) 2. database 3. business logic is contained in individual exe...
1
by: Chris | last post by:
Are there any performance issues with typed datasets in a fairly high performance system?
4
by: =?Utf-8?B?V2lsc29uIEMuSy4gTmc=?= | last post by:
Hi Experts, I am doing a prototype of providing data access (read, write & search) through Web Service. We observed that the data storing in SQL Server 2005, the memory size is always within...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.