[h2] H2 Performance Windows vs Linux
Greetings, incidentally I stumbled over a performance comparison related to H2 on Windows vs Linux: https://www.phoronix.com/scan.php?page=article&item=ryzen7pro-windows-linux&num=3 The difference looks relevant to me and I am curios to ask: Any idea why there is such a difference? I would actually have expected a very similar performance -- given that it runs within the JVM. Any thoughts on this? Warm regards Andreas -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/18e458764a6d810175c894090e53b181541cfebd.camel%40manticore-projects.com.
[h2] Re: upgrade to 2.0.202 ARRAY issue
Never mind, I read the documentation correctly this time, arrays are typed now. On Tuesday, 21 December 2021 at 10:22:50 UTC+2 pieter...@gmail.com wrote: > Hi, > > Running > > CREATE TABLE "PUBLIC"."V_Person" ("ID" IDENTITY NOT NULL PRIMARY KEY, > "age" ARRAY); > > fails with > > Syntax error in SQL statement "CREATE TABLE ""PUBLIC"".""V_Person"" > (""ID"" IDENTITY NOT NULL PRIMARY KEY, \000a\0009""age"" ARRAY[*]);"; > expected "IDENTITY, data type"; SQL statement: > CREATE TABLE "PUBLIC"."V_Person" ("ID" IDENTITY NOT NULL PRIMARY KEY, > "age" ARRAY); [42001-202] > > This work on 1.4.200, > Can someone show me the correct syntax please? > > The same sql works for other data types. > > Thanks > Pieter > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/51bd8aed-23a1-4114-849b-ae376b24713dn%40googlegroups.com.
[h2] upgrade to 2.0.202 ARRAY issue
Hi, Running CREATE TABLE "PUBLIC"."V_Person" ("ID" IDENTITY NOT NULL PRIMARY KEY, "age" ARRAY); fails with Syntax error in SQL statement "CREATE TABLE ""PUBLIC"".""V_Person"" (""ID"" IDENTITY NOT NULL PRIMARY KEY, \000a\0009""age"" ARRAY[*]);"; expected "IDENTITY, data type"; SQL statement: CREATE TABLE "PUBLIC"."V_Person" ("ID" IDENTITY NOT NULL PRIMARY KEY, "age" ARRAY); [42001-202] This work on 1.4.200, Can someone show me the correct syntax please? The same sql works for other data types. Thanks Pieter -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/fadca281-3313-49b7-a4f3-11fa7e5ccb15n%40googlegroups.com.