Kevin,

>I ran a little test a minute ago, it opens the Database, then opens 10 FPDos tables, and then opens 12 views with NODATA - this takes 95 seconds.

Too me it seems way to slow, even for a 1024 K network. A few points to check:

1. Pack your tables frequently to make sure that they do not contain lots of deleted records at the beginning of the file.

2. Index you tables wisely. Do not use low-selective indexes (such as indexes on DELETED() and indexes on other logical fields), when accessing this table rushmore might be forced to use these indexes and loads the from the server which might take some time on larger tables. Use high selective indexes (such as on Primary keys) as much as possible; the really give rushmore a boost.

3. Check how much time it takes to load the views. They might be the culprit here. Check if the're optimized (Note: FULL OPTIMIZATION might be very much slower than PARTIAL OPTIMIZATION). Just figure out which indexes you need to reach maximum performance.

4. you previously said it takes around 3 minutes to open around 50 views and 20 tables. This is quite a lot for only one form. Do you need these views and tables all at once, or is it possible to delay the opening of these tables to a point when they're nessary ?

5. The same for REQUERY. Only requery when neccesary. If the view data is on a page which is not active at the moment, it might not be neccesary to requery it before you activate the page assosiated with it.

HTH,

Walter,

>Does that sound reasonable to you?
>
>Kev