Thomas, your test case cannot be correct - notice that they are both
reading the same amount of data. The only reason the second is faster is
because the data is cache-hot after you have run the first query.
On 2012-05-01 07:50, Thomas Egense wrote:
/*
total: 67483
TRIPPLETCOUNT.RELATION_IN read: 17919 (26%)
TRIPPLETCOUNT.TRIPPLETCOUNT_DATA read: 49564 (73%)
*/
/*
total: 67483
TRIPPLETCOUNT.RELATION_IN read: 17919 (26%)
TRIPPLETCOUNT.TRIPPLETCOUNT_DATA read: 49564 (73%)
*/
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
