Q:
Improving the initial speed of a SQL query
I have optimized my SQL query to the maximum extent.
The first time I ran the query, it took 7 seconds; the next time it took half a second.
Why did this happen? How can I make the query run faster the first time around?
The first time I ran the query, it took 7 seconds; the next time it took half a second.
Why did this happen? How can I make the query run faster the first time around?
ASKED:
Jul 21 2009 6:11 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
+1
Click to Vote:
+1
Click to Vote:
- 1
0
