Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement