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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/f65664f9-6580-460f-9a20-22607b63f2f3n%40googlegroups.com.