General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only