Does anyone have a good method of querying lookup table data in a multi-datasession environment? We've been investigating methods of querying lookup table data at application startup and saving it in order to avoid having to requery it every time we need it (for populating combo boxes and whatnot). One method we've used in the past is to query the data (using views), and copy it to global arrays. In that way, the data would be available to all datasessions. Does anyone have a better idea?

Any suggestions would be appreciated.