What means "H2 QUERY_CACHE_SIZE (default :8)"? 8 MB???

105 views
Skip to first unread message

snookerms

unread,
Oct 28, 2012, 6:17:25 AM10/28/12
to h2-da...@googlegroups.com
Hello,

what means "H2 QUERY_CACHE_SIZE (default :8)"?

Is the size of the QUERY_CACHE_SIZE 8MB ??

Thomas Mueller

unread,
Oct 28, 2012, 7:44:21 AM10/28/12
to h2-da...@googlegroups.com
Hi,

This is the size of the query cache, in number of cached statements.

Regards,
Thomas


snookerms

unread,
Oct 28, 2012, 9:06:12 AM10/28/12
to h2-da...@googlegroups.com
And a statement ist a SQL-SELECT-Query.

So the complete Result Set is cached from the Query/statement?

Thomas Mueller

unread,
Nov 2, 2012, 11:55:40 AM11/2/12
to h2-da...@googlegroups.com
Hi,

> So the complete Result Set is cached from the Query/statement?

Yes I believe that's true, for smaller results.

Regards,
Thomas
Reply all
Reply to author
Forward
0 new messages