Re: [h2] Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)

Provided herehttps://groups.google.com/forum/?hl=it#!topic/h2-database/lNp80bgbvBY. Thanks! Il giorno giovedì 22 maggio 2014 17:43:18 UTC+2, Thomas Mueller ha scritto: Hi I would need a reproducible test case, or the database file. Regards, Thomas On Thursday, May 22, 2014, jack jin

Re: [h2] Re: Corruption in a database created in 1.3.174 when opening and closing it in 1.3.176

Thank you, I hope you'll manage to fix this. Let me know if I can be of some help. Let me add that: - version 175 seems to behave like 174, so the problem seems to be between 175 and 176. - the latest 2 beta versions seem to be ok Thanks, Germano Il giorno giovedì 22 maggio 2014

Re: [h2] CreateCluster replication speed

Hi Thomas Ok. Thanks for the clarification. I have had a look at the CreateCluster tool. I am working a bit on modifying it to use FTP to copy the database files to make the startup faster when having large databases. I intend to use the FTP server in H2 along with some on-the-fly compression.

[h2] insert sorted/direct

Not sure what either of these do. The docs: When using DIRECT, then the results from the query are directly applied in the target table without any intermediate step. When using SORTED, b-tree pages are split at the insertion point. This can improve performance and reduce disk usage. What