Hi
From the performance trace, it appears that you are not managing to hit our ConditionInConstantSet optimisation, which
will lead to rather slow queries with large numbers of values to test.
I see 2 options
(a) you construct us a standalone test-case and I can see why it fails to get
optimised
(b) you can step through the code in org.h2.expression.ConditionIn#optimize(Session) yourself, and see why it doesn't
trigger.
Regards, Noel.
On 2015-07-07 02:40 PM, Dimitris Balaouras wrote:
Hi Thomas,
There are only 5000 records in the DB. But do note that the IN () statement,
contains a very large number of
IDs..potentially thousands.
--
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 post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
