>I conducted a speed test on opening a database, some tables and some views, here were my results (from an NT Server):
>
>1 Database 1 Second
>8 Tables(some free, some from database 12 Seconds
>3 Views (with NODATA) 18 Seconds
>
>My main concern is the views, how come the views take longer to open the tables even with NODATA issued? surely they should be quicker - or is it not?
>
>Comments welcome
>Kev

Hi Kev,

The answer is rhusmore. When you use a view ( with NODATA ) VFP try to optimize the SQL and load portion of the index file.

There are a lot of threads about the use of unbalanced index like ( deleted index ) and the impact on the network traffic .

You are able to use SMS to see the network traffic and optimize your application. I do this to run my application on a 4MB Token Ring corporate network.

Marcel