BTW, when you say "opening a view", you mean USE NODATA? Or are you grabbing data too? Is the view in a .DBC on the server and is it possible 2 or more people are using this view at the same time?
Jim's correct, unless you are doing some really weird and complex stuff or your 1,000 record table is chock full of *huge* memo fields, it shouldn't take even 1 second to open a view.
Are the tables that make up the view open before using the view? If they are not, there may be a delay opening one or more of the underlying tables.
>Hello, > >Universal Thread has been really helpful however as of now I'm really at wits end... :-\ > >The users are complaining that the time response is very slow. We have a new Windows 2000 server - Dell PowerEdge 4400, "x86 Family 6 Model 8 Stepping 6 GenuineIntel ~993 Mhz", 1 GB RAM, 17 GB on drive C (utility stuff) and 87 GB on drive D (VFP database/tables). I ran a simple test - a simple view. The table consists of 1,000 records. Using VFP (not a compiled application), opening the view takes less than a second (about 100 records out of 1,000). With another user logged on but without opening the view, it takes 8 seconds. If the other user opens the view, it takes 10 seconds. Now that's just opening a simple view by itself, not running any form, nor any application, whatsoever. > >I tried disabling the anti-virus program on the server as well as on the workstations to no success. The anti-virus software on the server (as well as the workstations) is McAfee, not Norton. So it's definitely not the anti-virus software. Anything else I can look into...? > >Help... :-\