I have a bunch of value lists that update according to the number of records in the file, for example, one of them shows the record ID and the contact name. They draw from those two fields in the contact table. There are about 3,000 records in the data table.
These take forever to load sometimes, and I wonder if there's a faster way to make them load?
I've tried loading them all into a separate table, just those two fields, and updating that table daily, but the load time is still very long. Of course, once the index is created, they zip along OK.
All the best,
JB, The Creative One