[h2] Recent drops in performance

2019-03-27 Thread Joe Littlejohn
Hi I'm running H2 like: java -cp $H2_JAR org.h2.tools.Server \ -ifNotExists \ -tcp -tcpPort 9092 \ -baseDir "/var/tmp" & I have noticed that recent releases of H2 seem drastically slower than previous releases. Between 1.4.197 and 1.4.198, I can see that

[h2] License Statement for #1833

2019-03-27 Thread Joe Littlejohn
Hi Regarding the code pushed as part of https://github.com/h2database/h2database/pull/1833 I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed under the MPL 2.0, and the EPL 1.0 (http://h2database.com/html/license.html). Cheers Joe Littlejohn --

[h2] Re: Linked Tables & Indexes

2019-03-27 Thread Evgenij Ryazanov
Database B will pass some commands to database A, how they will be actually executed and how indexes will affect execution plan is a problem of database A, database B has nothing to do with it. -- You received this message because you are subscribed to the Google Groups "H2 Database" group.

[h2] Re: Linked Tables & Indexes

2019-03-27 Thread Jack Green
Thanks for getting back to me. Just to be clear... You have database A, with indexes You have database B, which has is linked to A If you query A, it uses the indexes. If you query A’s tables in B, it uses the index - you just cant see the indexes? Is this correct? -- You received this