Hi, The branch https://github.com/nicolas-f/h2database/tree/h2-spatial is ready to be merged. I will add the SQL Alias later. I will now work on H2 Driver. H2 GIS has been updated to work on h2-spatial branch and is built here Last jenkins build<http://jenkins.orbisgis.org/view/H2%20GIS/job/H2GIS%20Deploy/lastBuild/org.h2gis$h2-dist/>
The file h2-dist-0.1-SNAPSHOT-bin.zip<http://jenkins.orbisgis.org/view/H2%20GIS/job/H2GIS%20Deploy/lastBuild/org.h2gis$h2-dist/artifact/org.h2gis/h2-dist/0.1-SNAPSHOT/h2-dist-0.1-SNAPSHOT-bin.zip>contain h2 spatial and h2 gis. I try an intersection test and thanks to your great spatial index on disk, it goes from 127sec without index to 10 sec with index, nice speed-up. I do a small change in ValueJavaObject, please review this commit https://github.com/nicolas-f/h2database/commit/17b730f481bc1014a7dfbaa6595bf8c63def1129 . I set the @author tag on modified classes, we agree with h2 license. -Nicolas Fortin Atelier SIG IRSTV FR CNRS 2488 Le mercredi 17 juillet 2013 10:49:24 UTC+2, Nicolas Fortin (OrbisGIS) a écrit : > > Hi Thomas, > > Really great, thank you. I will do more tests, then it will be ready to > merge with trunk. > > -Nicolas Fortin > Atelier SIG > IRSTV FR CNRS 2488 > > Le mardi 16 juillet 2013 22:51:09 UTC+2, Thomas Mueller a écrit : >> >> Hi, >> >> I found and fixed the problem now. It wasn't a concurrency problem at all >> (although I did fix a potential concurrency issue as well). The problem was >> the same page could be freed up twice, which ended up with a negative fill >> ratio for the chunk. This is fixed now in the trunk. >> >> By the way, the reason why it doesn't show up earlier is that the problem >> only appeared when the background thread was compacting, and this is done >> after 45 seconds (so that data in the file is not overwritten for 45 >> seconds). This is done for added data protection in case of power failure >> and to avoid having to call fsync, see also >> http://stackoverflow.com/questions/13650134/after-how-many-seconds-are-file-system-write-buffers-typically-flushed- >> but for testing you could change it using MVStore.setRetentionTime(1000). >> >> Regards, >> Thomas >> > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
