form open very slow

[csvideo]

I have a form that has three parameterized views in it's DE
the views are set to load without data. The views piont to base tables with over 120000,55000,56000 respectively. When I running the form it takes about 30 seconds before it's displayed. What can I do to speed this up?

N.B All the base tables are index on a primary key field

 

[fluteplr]

1. What is very slow, 10 seconds? 10 minutes?
2. How long does it take to open these views from the command line using the nodata parameter?

In certain cases I have found that is sometimes faster to open a parameterized view with a parameter that you know will return zero records than using the nodata option.

 

[rgbean]

Is this application (.DBC) used by a lot of concurrent users? Are you storing / creating these views locally or in the "shared" .DBC? When keeping your View defintions in the shared .DBC, there can be a lot of contention - slow downs. There been multiple discussions about this on both the UT (

http://www.universalthread.com)

and the Wiki (e.g.

http://fox.wikis.com/wc.dll?Wiki~CreatingDBCforViews~VFP).

Rick