Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>Caching will happen because the second set of joins and the where clause is the same as the first. SQL Server does the same thing via "Simple Parameterization"
>
>We're not talking about doing the SQL two times in a row. It is slow the first time if I don't have the inclusion of additional fields. So, this shows there is something going on somewhere. If I only include the field such as Member.Numero,Item.Numero, it is slow. But, if I include the field such as Member.Numero,Item.Numero,Status.*, then the result is immediate. So, I cannot understand what you mean by Caching. Maybe I missed something?
You did run the query twice, the first time with one set of fields and the second time with a different set of fields. Unless you restart your machine, you're using cached data for the second query.
Précédent
Suivant
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