Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table vs View design philosophy
Message
From
16/03/1999 16:20:43
Dave Nantais
Light speed database solutions
Ontario, Canada
 
 
To
16/03/1999 14:08:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00198141
Message ID:
00198330
Views:
17
>>i have obtained "very close to native table performance" using local views.
>>users access a file server on a novell network across a standard LAN line ..
>>can you give me a concrete example where native table access would be significantly faster than using local views?
>>TIA , Dave.
>
>One example: if you have large table on network with SET DELETED ON and you want to select 50 records by one filter criteria, then you may find that SEEK/SKIP will work faster than p-view.
>BTW: local views still use native access.

thanks for the example ,
i thought local views were just a giant wrapper for native access .. LOL
Dave.
Previous
Reply
Map
View

Click here to load this message in the networking platform