Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form Loading Speed

Status
Not open for further replies.

Toga

Technical User
Jul 21, 2000
234
US
I have a form that was incredibly slow to load because it was linked to the underlying data tables with approximately 60000 records. I have redesigned this form so it is now unlinked with, relatively speaking, an incredible speed improvement. One thing that still slow's it down some is a dropdown within the form that's still linked to all of these records...but only 2 of the fields.

It only took 2 years to accumulate this amount of records so in 2 more years I expect 120,000 records. My question is what can I do with the dropdown or be thinking about to prevent the form from opening slower & slower over time? Is there a common strategy that folks combat this with or will I need to eventually start archiving data into another table.

Thanks..Toga
 
It looks to me like you have already discovered the secret. Only return the recordset you need to deal with. If your database is designed properly then this should not be much of a problem. 120,000 records is not really that much to deal with. As far as archiving I stand on the above statement "Only return the recordset you need to deal with"
If the data is obsolete then archive it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top