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 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