Ok. It must be something like that then. (Although my experiences usually that query times are very stable and repeatable. Often 20% slower or so on the first run and then they settle down. In this case I was experiencing a dramatic speed up from about 10s to just 100ms.)
- mike On Mon, Apr 15, 2013 at 8:01 AM, Noel Grandin <[email protected]> wrote: > We don't store our query cache to disk. > > But the operating system will be caching disk contents itself, which will > make a large difference. > > You could try clearing the operating system disk cache, but you'd have to > have to google around to figure it out for your OS. > > > On 2013-04-15 04:52, Mike Goodwin wrote: >> >> Hi, >> >> Is it possible to clear the query cache? For the purposes of comparing >> query performance. >> >> Even restarting the database does not seem to work, so they must be >> getting cached to disk, >> >> thanks, >> >> Mike >> -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
