Any news from dissecting the databasefile I gave you? From, Thomas
On May 2, 10:58 am, Noel Grandin <[email protected]> wrote: > 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.
