Yes, doing a copy with PAGE_SIZE of 2k reduced the average query time even a bit more, to under 100ms. So this is mostly about the order of the data on disk.
On Wednesday, October 9, 2013 10:48:14 PM UTC-7, Noel Grandin wrote: > > > It's quite likely that a dump and restore improved the locality of > reference because all of the data belonging to a single table is now > packed tightly together. > > On 2013-10-10 06:04, Brian Craft wrote: > > > > Copying the db to a new db with PAGE_SIZE of 8k lowered the average > > query time by a factor of 20: from 10 sec to 0.5 sec. > > > > -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
