Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Slow responce for the first time
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00509242
Message ID:
00509361
Vues:
18
>>Hello,
>>
>>I'm working with SQL Server Query Analyzer
>>I found out that query runs much longer (up to 10 times longer) when there was some minutes delay (I'm not quite sure how long) after last time query was running.
>>I mean, that first to run query it's taking more time to return results than second etc.
>
>Surely because the data is in cache when the second query is executed.

How to make this data for ever in cache? :)
Giedrius
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform