This message serves for Google indexing. It only includes the first message of each thread from technical forums. To see the entire thread, the solutions and the technical content related to each message, you need to log in by going to the main page. This can be done at http://www.universalthread.com. If you do not have an account, we encourage you to create one now and start participating in Microsoft .NET and SQL Server related technology forums, just to name a few. Our database contains nearly two millions valuable high end technical messages. Thanks for the generous contribution to everyone who participated on the site so far, including MVP, Microsoft employees and many other well known contributors. The valuable content of the Universal Thread has created a history of 16 years of high end technical content which has helped many consultants, developers and many others in the industry on a daily basis. The site also offers a subscription option that greatly enhances your site experience.


View message
From09/07/1997 11:13:55
Sonny Chouinard #003125
CHCA Computer Systems Inc.
Lachenaie, Quebec, Canada
To  
All


I've tried to find a new way to use lookup tables. Now, I have a view for each lookup tables. It works fines but it's pretty slow each time I load a form. I used that method because it will be stored in a remote database.
Another way is to store all the information in arrays (properties in oApp). But I'm afraid that it will eat a lot of memory. Some lookup tables have 1000 records and I have about 40 lookup tables.
The last way I know is to make another LOCAL database and refresh it from the remote database (each day).

I am looking for new ways. Any help will be a lot appreciated.