Depending on your OS, there's a good possibility that the OS is caching
HD data. So instead of mysql reading directly from disk, it's getting
it from the memory cache. Depending on how heavily your server is used,
wait 10 or 15 mins (to let the memory cache clear out) and try it again.
Mike.
[snip]
When i do a query from a big table using indexes,it takes for example 5
seconds. Now if i, after
some time repeat the query, the query takes about 0.5 secs.
So far i thought it was because of caching, but now i read mysql (v3.23)
doesnt
support query cache. So this really gets me wondering,
2 matches
Mail list logo