Hi All,

I'm using Hibernate with MySQL and Spring. I put some timing code around one of my queries (an HQL from xxx query) to see how long it was taking. I saw the first call take about 300ms, then subsequent calls where all around 20ms. I don't have 2nd level caching enabled, so what could be causing the subsequent queries to run so quickly?

Thanks,
Fred

Most databases have a internal cache too, where they store read pages.
When you issue the query for the second time, then probably
my-sql has the relevant pages already in cache and can deliver the query-result much faster
(only logical reads, no physical reads).