Hi,
Thanks a lot for the great test case! There are a two bugs in H2:
- h2.optimizeInJoin doesn't work correctly.
- Conditions such as "pk = ? AND pk > ?" don't work correctly.
Those problems will be fixed in the next release.
By the way, you should run the test for each database at least twice,
otherwise the JIT compiler can't do a good job. I used:
for (String url : Arrays.asList(h2url, h2url, mysqlUrl, mysqlUrl)) {
...
conn.close()
}
My results are now:
Testing jdbc:h2:mem:test
...
Initialization [125ms]
A. SELECT pk FROM t WHERE pk = ? [0ms]
B. SELECT pk FROM t WHERE pk IN (?, ?) [125ms]
C. SELECT pk FROM t WHERE pk = ? OR pk = ? [7688ms]
D. SELECT pk FROM t WHERE pk = ? AND pk = ? [31ms]
E. SELECT pk FROM t WHERE pk = ? AND pk > ? [0ms]
Total [7969ms]
Testing jdbc:mysql://localhost/test?user=sa&password=sa
...
Initialization [2063ms]
A. SELECT pk FROM t WHERE pk = ? [171ms]
B. SELECT pk FROM t WHERE pk IN (?, ?) [141ms]
C. SELECT pk FROM t WHERE pk = ? OR pk = ? [156ms]
D. SELECT pk FROM t WHERE pk = ? AND pk = ? [125ms]
E. SELECT pk FROM t WHERE pk = ? AND pk > ? [141ms]
Total [2797ms]
To verify my results you need to check out the latest source code and
build H2 yourself.
Regards,
Thomas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-database@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
