I'm playing around with a large H2 data set.The db in question is 40gb+, the table has 300 million records.+ Via JDBC.
When I do a simple "select * from mylargetable" it takes 10-15 minute before I see the first row, and the data starts flowing. This was unexpected as H2 has been extremely performant in all other situations. Is there something I can do to reduce this Time To First Row? If I add a limit on the query, the results start comming back faster, ex limit 10000 comes back sub second, 1000000 comes back in a few seconds, etc... The TTFR keeps growing as the limit increases. Is H2 trying to fully fill some buffer before starting to return data? -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/f65664f9-6580-460f-9a20-22607b63f2f3n%40googlegroups.com.
