I would like to know why when having big data in mysql table, executing a query for the first time takes 0.1.. sec, but if executing again the same query later, it will take only 0.0006 sec ?
SELECT name FROM
users where id > 310000 limit 20
takes: 0.1844 sec the first time executed
and it takes: 0.0006 sec when excecuted again
Is there caching or data management ?
The speed will stay permanently ~0.0006 after executing it for the first time ?
Thank you :)