"Store Large Lookup Tables in DataSets" by Roger Jennings
Visual Studio Magazine, July 2004

Readme.txt file for the OCEProject and OCETestClien.sln project

To test update submission, do the following:

1. Expand Databases.zip in the \OCEProject folder

2. Attach OCE_Cust_dat.mdf and OCE_Prod_dat.mdf to a network or local 
   SQLServer or MSDE 2000 instance.

3. Change the connection strings in the declarations section of OCEClient.vb
   to suit your installation, if necessary.

4. Find 'UserDomainName, "OAKLEAF"' in the code. 

5. Change OAKLEAF to your domain name to enable the Submit button.

6. Set blnUseDataAdapter = True. 

7. Temporarily set blnTestDates = False in the frmOCE_Client_Load event 
   handler to bypass the maximum age tests and create the DataSets.

8. Reset step 7's temporary changes.

9. Change intMaxAgeDays from the default 360 for this distributon to a
   more reasonable local DataSet update interval, such as 2.

Run tests with your typical client harward. Use the OCETestClient.exe file
in the ...\bin folder to obtain representative load times with the 10-MB
data file.

--rj

Source code copyright 2004 by Roger Jennings and OakLeaf Systems
All rights reserved.