[h2] Re: H2 and H2GIS with embedded Tomcat Tutorial Blog Post
Dear Iqbal, Glad to see such a project and thanks for sharing you job with the community. Erwan -- OrbisGIS and H2GIS leader Co-chair of the OGC Symbology Encoding SWG CNRS FR 2488 Institut de recherche en sciences et techniques de la ville École Centrale de Nantes BP 92101 1 rue de la Noë, 44321 NANTES Cedex 3 France Tél : 02 40 37 68 67 http://www.irstv.fr/ Le mardi 3 février 2015 17:24:11 UTC+1, IQBAL YUSUF a écrit : Hi All, I've written up a blog post titled Spatial IoT : Micro Map API Server : with embedded Tomcat, Spring, embedded H2GIS, GeoJSON on Raspberry PI http://blog.sortedset.com/spatial-iot-micro-map-api-server-embedded-tomcat-spring-embedded-h2gis-geojson-raspberry-pi/ In this blog I've detail steps to try out H2GIS with embedded Tomcat, Spring in a RESTful manner using GeoJSON. Let me know if you liked it? Thanks. Iqbal -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: Interfaces instead of direct JTS reference
Dear Steve, Offer interfaces instead of direct JTS object is a good option. As Nicolas points out, it will be very interesting to extend the geometry model to support OGC Simple Feature Specification for SQL. This idea is in our pipe. We have identified the current constraints to do that and you are welcome to exchange with H2GIS team and H2 guys. Could you explain what is not relevant to you with H2GIS , because we support all SFS operators, predicates and we have advanced spatial capabilities ? Erwan -- OrbisGIS and H2GIS leader Co-chair of the OGC Symbology Encoding SWG CNRS FR 2488 Institut de recherche en sciences et techniques de la ville École Centrale de Nantes BP 92101 1 rue de la Noë, 44321 NANTES Cedex 3 France Tél : 02 40 37 68 67 http://www.irstv.fr/ Le mercredi 4 février 2015 15:54:38 UTC+1, Nicolas Fortin (OrbisGIS) a écrit : You can't cast a wrapper to a wrapped object, this is why Java define the interface Wrapper. - - I understand your intention behind that... currently I do something like that in H2GIS's SpatialResultSetImpl Default implementation means without the presence of H2 jar and JTS jar. Then at least one implementation of the new Api should be provided by h2. You can't ask a user of the database to develop a third party library for a feature that are already in h2. - Default Implementation: A default implementation itself makes sense because H2 should be able to test their spatial index. Therefore I would suggest to implement a H2Envelope, H2Geometry, H2GeometryFactory or we can call it JTSEnvelope etc... which uses the JTS framework. The default implementation can be provided by a different jar or by H2GIS. -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: Interfaces instead of direct JTS reference
Hi Steve, Le mercredi 4 février 2015 17:32:56 UTC+1, Steve a écrit : Hi Erwan, there are two issues why I can't use H2GIS. *Issue 1: * the license - GPL 3 is not an option for us Oh. Sorry maybe you are working on a proprietary software ;-). In this case, you are right, H2GIS is not suitable for you. *Issue 2: * We are using a binary format which is different to WKB and we don't want to make huge workarounds, which allows us to convert our binary format to a WKB because that's an unnecessary overhead for us which brings us no benefit. I am a bit curious. Is your format compliant with a standard or a specification ? In addition our binary format supports more geometry types which are necessary for our application. More than the ISO 19107 geometry model ? Erwan. -- OrbisGIS and H2GIS leader Co-chair of the OGC Symbology Encoding SWG CNRS FR 2488 Institut de recherche en sciences et techniques de la ville École Centrale de Nantes BP 92101 1 rue de la Noë, 44321 NANTES Cedex 3 France Tél : 02 40 37 68 67 http://www.irstv.fr/ Am Mittwoch, 4. Februar 2015 17:09:44 UTC+1 schrieb bocher: Dear Steve, Offer interfaces instead of direct JTS object is a good option. As Nicolas points out, it will be very interesting to extend the geometry model to support OGC Simple Feature Specification for SQL. This idea is in our pipe. We have identified the current constraints to do that and you are welcome to exchange with H2GIS team and H2 guys. Could you explain what is not relevant to you with H2GIS , because we support all SFS operators, predicates and we have advanced spatial capabilities ? Erwan -- OrbisGIS and H2GIS leader Co-chair of the OGC Symbology Encoding SWG CNRS FR 2488 Institut de recherche en sciences et techniques de la ville École Centrale de Nantes BP 92101 1 rue de la Noë, 44321 NANTES Cedex 3 France Tél : 02 40 37 68 67 http://www.irstv.fr/ Le mercredi 4 février 2015 15:54:38 UTC+1, Nicolas Fortin (OrbisGIS) a écrit : You can't cast a wrapper to a wrapped object, this is why Java define the interface Wrapper. - - I understand your intention behind that... currently I do something like that in H2GIS's SpatialResultSetImpl Default implementation means without the presence of H2 jar and JTS jar. Then at least one implementation of the new Api should be provided by h2. You can't ask a user of the database to develop a third party library for a feature that are already in h2. - Default Implementation: A default implementation itself makes sense because H2 should be able to test their spatial index. Therefore I would suggest to implement a H2Envelope, H2Geometry, H2GeometryFactory or we can call it JTSEnvelope etc... which uses the JTS framework. The default implementation can be provided by a different jar or by H2GIS. -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: Interfaces instead of direct JTS reference
Hi Erwan, there are two issues why I can't use H2GIS. *Issue 1: * the license - GPL 3 is not an option for us *Issue 2: * We are using a binary format which is different to WKB and we don't want to make huge workarounds, which allows us to convert our binary format to a WKB because that's an unnecessary overhead for us which brings us no benefit. In addition our binary format supports more geometry types which are necessary for our application. Am Mittwoch, 4. Februar 2015 17:09:44 UTC+1 schrieb bocher: Dear Steve, Offer interfaces instead of direct JTS object is a good option. As Nicolas points out, it will be very interesting to extend the geometry model to support OGC Simple Feature Specification for SQL. This idea is in our pipe. We have identified the current constraints to do that and you are welcome to exchange with H2GIS team and H2 guys. Could you explain what is not relevant to you with H2GIS , because we support all SFS operators, predicates and we have advanced spatial capabilities ? Erwan -- OrbisGIS and H2GIS leader Co-chair of the OGC Symbology Encoding SWG CNRS FR 2488 Institut de recherche en sciences et techniques de la ville École Centrale de Nantes BP 92101 1 rue de la Noë, 44321 NANTES Cedex 3 France Tél : 02 40 37 68 67 http://www.irstv.fr/ Le mercredi 4 février 2015 15:54:38 UTC+1, Nicolas Fortin (OrbisGIS) a écrit : You can't cast a wrapper to a wrapped object, this is why Java define the interface Wrapper. - - I understand your intention behind that... currently I do something like that in H2GIS's SpatialResultSetImpl Default implementation means without the presence of H2 jar and JTS jar. Then at least one implementation of the new Api should be provided by h2. You can't ask a user of the database to develop a third party library for a feature that are already in h2. - Default Implementation: A default implementation itself makes sense because H2 should be able to test their spatial index. Therefore I would suggest to implement a H2Envelope, H2Geometry, H2GeometryFactory or we can call it JTSEnvelope etc... which uses the JTS framework. The default implementation can be provided by a different jar or by H2GIS. -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: Interfaces instead of direct JTS reference
Hi, This is a good idea. Few suggestions: - IEnvelope, IGeometryFactory, IGeometry and GeometryParseException should be in the API package of H2. - User defined function should be able to directly reference the wrapped spatial type. Then maybe add two methods like this interface http://docs.oracle.com/javase/7/docs/api/java/sql/Wrapper.html and manager this case when calling user defined function and table function. - H2 should provide itself a default implementation for ease of use (stackoverflow question http://stackoverflow.com/questions/27943435/what-is-the-syntax-for-running-a-spatial-query-in-h2/27949066#27949066). To change default implementation class you could use sys properties http://www.h2database.com/javadoc/org/h2/engine/SysProperties.html. - Currently all type of geometry are merged together into Geometry type. We should find a way to add a constraint to define for ex. a LINESTRING column that stay LINESTRING column when copying the table. (H2 Domain does not survive when doing CREATE TABLE MYTAB AS SELECT THE_GEOM FROM SRCTAB; -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Missing column type in right-hand parameter in ConditionIn
Hi Sorry this took so long, this patch has been applied. Nice work! Regards, Noel -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] is not null -- not working
Probably because you have stored the string null into your DB instead of an actual NULL value -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: ResultSet is empty when I move my database file from Windows to Linux environment.
Hi, If you use the H2GIS function FileTable it creates an empty table if the linked shape file is not found. If you want to embed the shape file in the database you should use SHPREAD instead. regards, -Nicolas Fortin -- IRSTV FR CNRS 2488 GIShttp://orbisgis.org Spatial DB http://h2gis.org Noise http://noisemap.orbisgis.org Le mardi 3 février 2015 18:34:47 UTC+1, IQBAL YUSUF a écrit : Hi All, I am having a weird problem. I've created a project in Windows environment. When I transfer the project to an Linux CentOS environment ResultSet is coming back empty rows. My code can be viewed from here https://github.com/iyusuf/micro-map-service/tree/master/src/main/java/com/sortedset/blog/micromapservice/spring Thanks. Iqbal -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Re: H2 database: slow query although index is used
Hi Sorry this took so long, your patch has been committed. Regards, Noel -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Using synchronized in user defined functions or not
Synchronized means that only thread at a time can execute the ALIAS, which will slow a multithreaded server down. Whether or not you need synchronized on that method is a different question, and depends on how the method is implemented. -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] PostgreSQL compatibility: generate_series (as an alias for system_range)
Hi Thanks a lot! Very nice unit tests! Your patch has been applied. Regards, Noel. -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: Interfaces instead of direct JTS reference
You can't cast a wrapper to a wrapped object, this is why Java define the interface Wrapper. - - I understand your intention behind that... currently I do something like that in H2GIS's SpatialResultSetImpl Default implementation means without the presence of H2 jar and JTS jar. Then at least one implementation of the new Api should be provided by h2. You can't ask a user of the database to develop a third party library for a feature that are already in h2. - Default Implementation: A default implementation itself makes sense because H2 should be able to test their spatial index. Therefore I would suggest to implement a H2Envelope, H2Geometry, H2GeometryFactory or we can call it JTSEnvelope etc... which uses the JTS framework. The default implementation can be provided by a different jar or by H2GIS. -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Re: ResultSet is empty when I move my database file from Windows to Linux environment.
Thanks Nicolas, That was it. I used FileTable instead of ShpRead. Using ShpRead solved the problem when I uploaded my code to my Linux server. Here is the running live app if anyone interested. http://java.sortedset.com/micromapserver/?Name=Brazil On Wed, Feb 4, 2015 at 2:06 AM, Nicolas Fortin (OrbisGIS) nico.de...@gmail.com wrote: Hi, If you use the H2GIS function FileTable it creates an empty table if the linked shape file is not found. If you want to embed the shape file in the database you should use SHPREAD instead. regards, -Nicolas Fortin -- IRSTV FR CNRS 2488 GIShttp://orbisgis.org Spatial DB http://h2gis.org Noise http://noisemap.orbisgis.org Le mardi 3 février 2015 18:34:47 UTC+1, IQBAL YUSUF a écrit : Hi All, I am having a weird problem. I've created a project in Windows environment. When I transfer the project to an Linux CentOS environment ResultSet is coming back empty rows. My code can be viewed from here https://github.com/iyusuf/micro-map-service/tree/master/ src/main/java/com/sortedset/blog/micromapservice/spring Thanks. Iqbal -- You received this message because you are subscribed to a topic in the Google Groups H2 Database group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/h2-database/txO0x2xRyeM/unsubscribe. To unsubscribe from this group and all its topics, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout. -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: Interfaces instead of direct JTS reference
My 2 cents: I'm working on open source Apache licensed software and H2GIS with GPL3 is incompatible here as well ;) So I'll be happy if alternative GIS extension for H2 with less restrictive license will appear. Sergi On Wednesday, February 4, 2015 at 8:14:10 PM UTC+3, bocher wrote: Hi Steve, Le mercredi 4 février 2015 17:32:56 UTC+1, Steve a écrit : Hi Erwan, there are two issues why I can't use H2GIS. *Issue 1: * the license - GPL 3 is not an option for us Oh. Sorry maybe you are working on a proprietary software ;-). In this case, you are right, H2GIS is not suitable for you. *Issue 2: * We are using a binary format which is different to WKB and we don't want to make huge workarounds, which allows us to convert our binary format to a WKB because that's an unnecessary overhead for us which brings us no benefit. I am a bit curious. Is your format compliant with a standard or a specification ? In addition our binary format supports more geometry types which are necessary for our application. More than the ISO 19107 geometry model ? Erwan. -- OrbisGIS and H2GIS leader Co-chair of the OGC Symbology Encoding SWG CNRS FR 2488 Institut de recherche en sciences et techniques de la ville École Centrale de Nantes BP 92101 1 rue de la Noë, 44321 NANTES Cedex 3 France Tél : 02 40 37 68 67 http://www.irstv.fr/ Am Mittwoch, 4. Februar 2015 17:09:44 UTC+1 schrieb bocher: Dear Steve, Offer interfaces instead of direct JTS object is a good option. As Nicolas points out, it will be very interesting to extend the geometry model to support OGC Simple Feature Specification for SQL. This idea is in our pipe. We have identified the current constraints to do that and you are welcome to exchange with H2GIS team and H2 guys. Could you explain what is not relevant to you with H2GIS , because we support all SFS operators, predicates and we have advanced spatial capabilities ? Erwan -- OrbisGIS and H2GIS leader Co-chair of the OGC Symbology Encoding SWG CNRS FR 2488 Institut de recherche en sciences et techniques de la ville École Centrale de Nantes BP 92101 1 rue de la Noë, 44321 NANTES Cedex 3 France Tél : 02 40 37 68 67 http://www.irstv.fr/ Le mercredi 4 février 2015 15:54:38 UTC+1, Nicolas Fortin (OrbisGIS) a écrit : You can't cast a wrapper to a wrapped object, this is why Java define the interface Wrapper. - - I understand your intention behind that... currently I do something like that in H2GIS's SpatialResultSetImpl Default implementation means without the presence of H2 jar and JTS jar. Then at least one implementation of the new Api should be provided by h2. You can't ask a user of the database to develop a third party library for a feature that are already in h2. - Default Implementation: A default implementation itself makes sense because H2 should be able to test their spatial index. Therefore I would suggest to implement a H2Envelope, H2Geometry, H2GeometryFactory or we can call it JTSEnvelope etc... which uses the JTS framework. The default implementation can be provided by a different jar or by H2GIS. -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Online backup using sql BACKUP TO
Hi, I found in the mail list topic https://groups.google.com/forum/#!topicsearchin/h2-database/online$20AND$20backup/h2-database/fzKaVrKmUzk about 'BACKUP TO' behavior. I would like to use backup without freezing db from uses. So I am wondering, what is current state with multithreaded mode? Is it stable now? -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: JRuby + Sinatra + H2 + ActiveRecord(Optional)
Hi Sheldon! H2 is very well supported by the jruby activerecord-jdbc-adapter project. https://github.com/jruby/activerecord-jdbc-adapter You can use either active record or sequel as an ORM. The only caveat is that the jar version of H2 in jdbc-h2 is maybe not the best version to use. It might be better to build H2 and use a newer version. Good luck, Max On Tuesday, January 20, 2015 at 3:42:27 PM UTC-5, Sheldon Hall wrote: Hi, Does anyone have an example of using an H2 database (in activerecord pattern or not) with JRuby and Sinatra? Has anyone tried this before? Trying to find some example code but haven't really found anything comprehensive. In addition it probably doesn't help that I'm new to most of those technologies. Any help would be greatly appreciated. Regards, -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] 1.4 beta creates much bigger database file
I also had problems with an mvstore db growing out of control (about 3GB for 1M rows). I updated to 1.4.184, reimported, and it was much smaller (100MB). So the recent changes have had a very positive effect. Unfortunately, I was using 1.4.178 because that was the current jar bundled with the jdbc-h2 ruby gem. That version doesn't seem like such a good default. On Monday, February 2, 2015 at 2:42:28 PM UTC-5, Damien Coraboeuf wrote: I have replaced by BLOB columns by BINARY(32000) ones (more than enough in our case). After exporting the database in SQL ('script' command), recreating a blank database and reimporting the SQL ('runscript'), I went from 1.7 Gb to 17 Mb. I'll monitor the database in the next days to see if the inflation starts again. Damien. On Monday, 2 February 2015 17:40:49 UTC+1, Damien Coraboeuf wrote: Hi, Speaking of real world example - we are using H2 1.4.x to hold results for a continuous delivery chain. With 1.4.177, our database was 600 Mb, and after a 'shutdown defrag', we went down to... 11 Mb. We switched to 1.4.184 but now, the database has grown up to 1.7 Gb. That's a serious issue for us :( The URL we use is: jdbc:h2:/opt/ontrack/database/data;MODE=MYSQL Damien. On Monday, 5 January 2015 18:15:56 UTC+1, Thomas Mueller wrote: Hi, OK, that's nice! There is still quite a lot of room for improvements, and I don't consider this completely fixed, but will not work on it with very high priority any longer. Regards, Thomas On Sunday, December 21, 2014, Steve McLeod steve@gmail.com wrote: Hi Thomas, The database file size in 1.4.184 is much, much better than in earlier 1.4.x releases. I've done some trials and these are my findings: 1.3.176: Fully loaded database after shutdown is 317 Mb 1.4.184: Fully loaded database after shutdown is 380 Mb This seems reasonable. On Friday, 19 December 2014 17:15:29 UTC+8, Thomas Mueller wrote: Hi, Version 1.4.184 should produce smaller database files than previous version (1.4.x - 1.4.182), maybe half or a third of the old file size. It would be great to get some real-world results! Regards, Thomas On Tue, May 6, 2014 at 6:24 PM, Thomas Mueller thomas.to...@gmail.com wrote: Hi, Some initial results: you can shrink the database by running shutdown compact or shutdown defrag. Each time this is run, it shrinks a few MB (up to some point, of course). This works, but it's relatively slow. Now the task is to make it faster. There are two ways: shrink it fully to the minimum size, and shrink it incrementally (like now) but faster. I'm working on that now. Regards, Thomas On Tue, May 6, 2014 at 11:39 AM, Steve McLeod steve@gmail.com wrote: Hi Thomas, I've sent you a private email with a link to the new database file, made with H2 1.4.178 Regards, Steve On Monday, 5 May 2014 07:46:16 UTC+2, Thomas Mueller wrote: Hi, The database file should shrink if you run shutdown defrag. The current compact algorithm is quite inefficient, that means the databases file is quite big on average. The highest priority is still to ensure it always works correctly, and when that's done I will work on more efficiently re-using disk space and specially compact the file faster when closing the database. Could you send me the new database file? It would be nice to have a real-world database file to test this. The last file you sent helped a lot, thanks to it I found some problems that completely prevented the file to shrink. Regards, Thomas On Sunday, May 4, 2014, Steve McLeod steve@gmail.com wrote: Hi Thomas, I tested the same large data import with H2 1.4.178, and there is no improvement over H2 1.4.177. Here are the file sizes, in both cases after the app has stopped: H2 1.3.176: pokercopilot.h2.db 301,669,352 bytes H2 1.4.178: pokercopilot.mv.db 1,023,037,440 bytes Let me know what I can do to help. Regards, Steve On Saturday, 19 April 2014 11:44:05 UTC+2, Steve McLeod wrote: Hi Thomas, Great! Glad I could help make your superb product even better. On Friday, 18 April 2014 21:38:27 UTC+2, Thomas Mueller wrote: Hi, Thanks a lot for the database! I know what the problem is now, but I couldn't fix it yet. The database file (pokercopilot2.mv.db) has about 181 MB of live data, the rest (about 78%) is not used. The mechanism to get rid of the unused space is not working as it should for this case (I think the problem is that b-tree nodes are not processed correctly). This will be fixed in the next release. Regards, Thomas On Fri, Apr 18, 2014 at 5:29 PM, Steve McLeod steve@gmail.com wrote: Hi Thomas, I've sent a link to file privately to your email address. Regards, Steve On Friday, 18 April 2014 14:04:37 UTC+2, Thomas Mueller wrote: Hi, Hm, that didn't help much. Could you send me the (compressed) database files please?