--
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+unsubscribe@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
It's hard to tell what is happening without a concrete dataset or at least the complete DDL.
Please do so if the above suggested solution does not work for you.
Also, which version are you testing against?
One of our recent versions had a regression where it prepared statements slower than before.
The solution to your problem is to redesign your database. Read up on database normalisation.
If you need ad hoc, complicated queries, first load your data from your normal schema into a star schema as described in database warehouse textbooks.
--
You received this message because you are subscribed to a topic in the Google Groups "H2 Database" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/h2-database/6B5Sla2PkG8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to h2-database+unsubscribe@googlegroups.com.
To unsubscribe from this group and all its topics, send an email to h2-database...@googlegroups.com.