Hi H2 Group, I am trying to take advantage of the query cache, but I am getting some unexpected results (h2-1.3.173.jar)
In a single session, if I run a query A, and then repeat the query A, the second result is returned very fast (0-1 ms). However, if I run query A, then query B, and then query A again, the result for A is not returned that much faster than the first time. I would have expected the results of A (which are rather small) to still be cached, as the default is 8 results in the query cache (if I have understood it correctly). It seems as though only one result set is ever cached. Any thoughts? Here is some info about my setup: embedded mode, close_delay=-1, using prepared statements. On a similar note, it seems like a global query cache, as opposed to a separate one for each session, would be useful. Thanks, -Adam -- 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. For more options, visit https://groups.google.com/groups/opt_out.
