Here's a java.hprof.txt link for this. Again it was run on a 1Ghz i386/ Linux box, and even with this shortened query takes 17 seconds: http://kensystem.com/h2-time.zip
SELECT objId,b FROM om WHERE b IN (1,2) AND objId IN (1254619816788000000,1176099280681000000) H2 was started with: java -Xrunhprof:cpu=time,depth=8 -Xmx256M -DRETURN_LOB_OBJECTS=false - jar h2-1.2.128.jar org.h2.tools.Server -webAllowOthers -tcpAllowOthers -tcpPort 9101& (note this profiling mode took enough time that I needed to send a term signal to java, before the query completed) -- 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.
