I have figured out regarding the storage and loading of lookups. Managed to load the lookup data from DB table. Any advice on the number of lookups? Is one lookup with 600K records better than 6k lookups with 100 records each? The lookups will be refreshed a few times in a day based on an event trigger. Periodic refresh is not needed. Thanks, AR.