Hi
We currently use H2 1.4.187 version.
I have run a SQL request to run. To simplify let say:
SELECT A1,A2 FROM A;
The request take about 28 seconds to execute (there is a important INNER
JOIN) with H2 Console (Max rownum set to 1000).
This response time is very fine (considering the huge number of lines we
have).
However if we nested it in another SELECT clause like this (The result
should be the same as the request above):
SELECT * FROM (
SELECT A1,A2 FROM A)
The response time is catastrophic.
What's wrong?
Regards
Laurent
--
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.
