[h2] Maven SNAPSHOT artefacts

2015-10-29 Thread Sergi Vladykin
Guys, I think it would be great if the latest nightly build will be accessible as maven SNAPSHOT build. It seems that it is not needed to upload it into maven.org but it is enough to create correct maven repo structure on h2database.com website. Then it will be possible to point to it as a

[h2] What's your experience which huge databases (5M+)?

2015-10-29 Thread Thomas Mueller
Hi, 5 million rows isn't all that huge, the following script will create a table with that many records in about 40 seconds. The database size is about 100 MB (after "shutdown defrag"): drop table if exists test; create table test( id int primary key, name varchar(255), created timestamp)

Re: [h2] Indexing user defined tables

2015-10-29 Thread Noel Grandin
On 2015-10-28 04:49 PM, Dietmar Höhmann wrote: Looking into the "documentation" ;-), I think it might be an option to subclass org.h2.index.PageBtreeIndex and adapt it to use my ud table instead of an internal table. Could that work? (Could it work without messing with the packages?) You

Re: [h2] Indexing user defined tables

2015-10-29 Thread Dietmar Höhmann
Yes, I see the point. PageBtreeIndex is a bit to deep and to specific. Studying the code to more detail, I've found RegularTable to do 90% of what I need. It must get a custom ScanIndex and a way to update all indexes but the ScanIndex (for changes coming from the Notes side). And that's it. Of

[h2] Re: What's your experience which huge databases (5M+)?

2015-10-29 Thread Benjamin Asbach
My initial thought was rows. I know it makes a difference if you have 10 or 100 columns. I just want to get a feeling how and if others handle huge amount of data. Thanks Benjamin Am Mittwoch, 28. Oktober 2015 12:11:54 UTC+1 schrieb Steve McLeod: > > 5M+ whats? rows? bytes? > > > On Tuesday,

Re: [h2] H2 TCP server and SSL: how to use it?

2015-10-29 Thread Manfred Rosenboom
Sorry for the late answer. I have just tested it in Java 7 and it works as desired. My environment is set to Java 8 by default and you get the above mentioned error. Best Manfred Am Freitag, 16. Oktober 2015 16:31:25 UTC+2 schrieb Thomas Mueller: > > Hi, > > It works for me with Java 1.6 and

[h2] Re: Indexing user defined tables

2015-10-29 Thread Nicolas Fortin (OrbisGIS)
Hello, We have implemented our own TableEngine for external DBF files (DBASE III) It support virtual primary key column, spatial index (only for SHP files), and have some easy to use interfaces in order to add future offdb tables. The table implementation is here