try a query like select * from table where field in (1,2,3,....., 10.000)
try with 1000, 10000 or more elements. this is very slow even with memory db (for example it's more fast in postgresql) the bottleneck seems the internal filter (check value in the array sequentially, maybe more performance using an hashmap) -- 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.
