[h2] Re: Where is the NetBeans IDE Plugin hosted now? Kenai has now been shut down.

2017-05-19 Thread 'Adrian A.' via H2 Database
Nobody know anything about this? > > Many Kenai projects simply disappeared since no "readonly" archive was left behind like Google Code did. The author of the plug-in could know more: https://github.com/jtakakura or it might have a copy of the sources. Regards. -- You received this message

[h2] MVStore usage without versions

2017-05-19 Thread csizmazia . tamas
Hi all, We are trying to switch to MVStore because it is quicker than our previous backend. Unfortunately we found that - since we have large data set and modify it frequently - the file size is growing excessively. We tried to use *store.setVersionsToKeep(0)* when creating the store and *stor

Re: [h2] Concurrent update error in append only table

2017-05-19 Thread Marco Willemart
Actually it happens in the context of a long running process where the steps are executed concurrently. Some transactions can span a few minutes, however the inserts are small and fast and happen at the end of each step. It happens in production only because we process real data. In dev mode th

Re: [h2] Any negative effects of a large varchar type?

2017-05-19 Thread Noel Grandin
we store rows using a variable length structure, so there is no penalty -- 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.

Re: [h2] Split DB based on Date

2017-05-19 Thread Noel Grandin
if you want to implement something like this, your best bet is try something like: (*) every X days create a new table that you insert data into, and drop the oldest table (*) create a VIEW that UNIONs all of the current tables (*) do all your inserting using the latest table name (*) do all of

Re: [h2] Does data file splitting increase performance?

2017-05-19 Thread Noel Grandin
you're welcome to try, but I doubt it will make much, if any, difference. -- 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

Re: [h2] Concurrent update error in append only table

2017-05-19 Thread Noel Grandin
it's not locking the table. you are inserting a row that generates a constraint violation, so it throws an exception. If I fixed it, the only difference would be the __kind__ of exception you would see. -- You received this message because you are subscribed to the Google Groups "H2 Database