Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow responce for the first time
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00509242
Message ID:
00509361
Views:
17
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform