Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
>Bit confused here. Is the SQL faster or the view?
> The QUERY taxes the network an order of magnitude less than the View.
>
>Anyways, using a view also reads from the database. If the database is on the network, it is expected that reading from the view is slower. But there is more to it. If you specify a database(!) prefix in the from clause it is reading more from the network than when reading from an already open alias.
>
> I removed the SN! but it didn't seem to make any difference.
Make the DBC readonly and it should be the same. The view is reading from the DBC, causing the extra network trafic. By making it readonly the DBC can be cached.
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