I've implemented optimized handling for this specific case , code
checked into SVN.
On 2012-11-18 12:27, nzanaga wrote:
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.
